”;
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 earlier versions of Excel. You can find this information in the applicability section of the function.
Date and Time Functions
The following table lists all the Date & Time functions −
| S.No. | Function and Description |
|---|---|
| 1 | DATE
Returns the serial number of a particular date. |
| 2 | DATEDIF
Calculates the number of days, months, or years between two dates. |
| 3 | DATEVALUE
Converts a date in the form of text to a serial number. |
| 4 | DAY
Converts a serial number to a day of the month. |
| 5 | DAYS
Returns the number of days between two dates. |
| 6 | DAYS360
Calculates the number of days between two dates, based on a 360-day year. |
| 7 | EDATE
Returns the serial number of the date that is the indicated number of months before or after the start date. |
| 8 | EOMONTH
Returns the serial number of the last day of the month before or after a specified number of months. |
| 9 | HOUR
Converts a serial number to an hour. |
| 10 | ISOWEEKNUM
Returns the number of the ISO week number of the year for a given date. |
| 11 | MINUTE
Converts a serial number to a minute. |
| 12 | MONTH
Converts a serial number to a month. |
| 13 | NETWORKDAYS
Returns the number of whole workdays between two dates. |
| 14 | NETWORKDAYS.INTL
Returns the number of whole workdays between two dates (international version). |
| 15 | NOW
Returns the serial number of the current date and time. |
| 16 | SECOND
Converts a serial number to a second. |
| 17 | TIME
Returns the serial number of a particular time. |
| 18 | TIMEVALUE
Converts a time in the form of text to a serial number. |
| 19 | TODAY
Returns the serial number of today’s date. |
| 20 | WEEKDAY
Converts a serial number to a day of the week. |
| 21 | WEEKNUM
Returns the week number in the year. |
| 22 | WORKDAY
Returns the serial number of the date before or after a specified number of workdays. |
| 23 | WORKDAY.INTL
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 | YEAR
Converts a serial number to a year. |
| 25 | YEARFRAC
Returns the year fraction representing the number of whole days between start_date and end_date. |
”;