Excel Spreadsheets Date and Time Functions (21)
The DATEDIF doesn't show in the drop-down list of Excel functions (even in Excel 2007).
Most of the difficulties that users have with these functions come from the cell's format.
Importance
Functions
What it Does
Interesting
DATE
Returns the serial number of a particular date
Interesting
DATEDIF
Calculates the interval in days, months or years between two dates
Interesting
DAY
Converts a serial number to a day of the month
Interesting
HOUR
Converts a serial number to an hour
Interesting
MINUTE
Converts a serial number to a minute
Interesting
MONTH
Converts a serial number to a month
Interesting
NOW
Returns the serial number of the current date and time
Interesting
SECOND
Converts a serial number to a second
Interesting
TIME
Returns the serial number of a particular time
Interesting
TODAY
Returns the serial number of today's date
Interesting
WEEKDAY
Converts a serial number to a day of the week
Interesting
YEAR
Converts a serial number to a year
Rarely Used
DATEVALUE
Converts a date in the form of text to a serial number
Rarely Used
DAYS360
Calculates the number of days between two dates based on a 360-day year
Rarely Used
EDATE
Returns the serial number of the date that is the indicated number of months before or after the start date
Rarely Used
EOMONTH
Returns the serial number of the last day of the month before or after a specified number of months
Rarely Used
NETWORKDAYS
Returns the number of whole workdays between two dates
Rarely Used
TIMEVALUE
Converts a time in the form of text to a serial number
Rarely Used
WEEKNUM
Converts a serial number to a number representing where the week falls numerically with a year
Rarely Used
WORKDAY
Returns the serial number of the date before or after a specified number of workdays
Rarely Used
YEARFRAC
Returns the year fraction representing the number of whole days between start_date and end_date