Advanced Excel Functions Tutorial
Useful Resources
Selected Reading
- Statistical Functions
- Math & Trignometric Functions
- Lookup & Reference Functions
- Advanced Excel Functions - Logical
- Information Functions
- Financial Functions
- Engineering Functions
- Date & Time Functions
- Database Functions
- Advanced Excel Functions - Cube
- Compatibility Functions
- Advanced Excel Functions - Home
Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Date & Time Functions
Advanced Excel - Date & Time Functions
Excel Date and Time functions can be used to extract information from, and perform operations on, Excel Dates and Times.
Some of the Excel Date & Time functions are new to Excel 2010 or Excel 2013, so are not available in earper versions of Excel. You can find this information in the apppcabipty section of the function.
Date and Time Functions
The following table psts all the Date & Time functions −
| S.No. | Function and Description |
|---|---|
| 1 |
Returns the serial number of a particular date. |
| 2 |
Calculates the number of days, months, or years between two dates. |
| 3 |
Converts a date in the form of text to a serial number. |
| 4 |
Converts a serial number to a day of the month. |
| 5 |
Returns the number of days between two dates. |
| 6 |
Calculates the number of days between two dates, based on a 360-day year. |
| 7 |
Returns the serial number of the date that is the indicated number of months before or after the start date. |
| 8 |
Returns the serial number of the last day of the month before or after a specified number of months. |
| 9 |
Converts a serial number to an hour. |
| 10 |
Returns the number of the ISO week number of the year for a given date. |
| 11 |
Converts a serial number to a minute. |
| 12 |
Converts a serial number to a month. |
| 13 |
Returns the number of whole workdays between two dates. |
| 14 |
Returns the number of whole workdays between two dates (international version). |
| 15 |
Returns the serial number of the current date and time. |
| 16 |
Converts a serial number to a second. |
| 17 |
Returns the serial number of a particular time. |
| 18 |
Converts a time in the form of text to a serial number. |
| 19 |
Returns the serial number of today’s date. |
| 20 |
Converts a serial number to a day of the week. |
| 21 |
Returns the week number in the year. |
| 22 |
Returns the serial number of the date before or after a specified number of workdays. |
| 23 |
Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days. |
| 24 |
Converts a serial number to a year. |
| 25 |
Returns the year fraction representing the number of whole days between start_date and end_date. |