Excel Spreadsheets Functions: Date and Time

 613-749-4695 [email protected]

 This page is offered to you as referenceYou will probably use only 60% of  these Excel spreadsheet functions See Excel Date & Time formulas in chapter 15

# Excel Lesson 24B of 24: Excel Spreadsheets  Date and Time Functions List (20)

Here is the list of the functions of the date & time  category. Of the 20 functions of the date & time category 12 are interesting and useful. Follow the links below to discover formulas using them.

The DATEDIF doesn't show in the drop-down list of Excel functions see the page on formulas about how to use it.

Most of the difficulties that users have with these functions come from the cell's format. See the page on formulas on how to solve your problems.

Importance Functions What it Does
Interesting DATE Returns the serial number of a particular date
Interesting

DATEDIF

Calculates the interval 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

 Discover Even More in 50 Excel spreadsheets

 613-749-4695 [email protected]