Excel Spreadsheets Functions: Date and Time
|
613-749-4695 |
Tips and Ideas on Excel |
Tips and Ideas on Macros |
This page is offered to you as reference 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 |
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 |
Next Chapter: Engineering Functions in Excel |
Excel Table of Contents |
Discover Even More in 50 Excel spreadsheets |
|
613-749-4695 |
Tips and Ideas on Excel |
Tips and Ideas on Macros |
Excel Spreadsheets Functions: Date and Time