Date & Time(Microsoft Excel Functions)
Contents
Functions
Functions to manipulate date and time.
| Function | Importance | Description |
|---|---|---|
| WORKDAY WORKDAY.INTL | High | Get the date (serial value) after the specified number of business days. |
| EDATE | High | Get a date (serial value) after the specified month, taking into account the last day of the month. |
Function to get the date and time.
| Function | Importance | Description |
|---|---|---|
| DATE | High | Get date (serial value) by specifying year, month, and day. |
| TIME | High | Get time (serial value) by specifying hour, minute, and second. |
| TODAY | High | Get the date(serial value) of the day. |
| NOW | High | Get the current date and time (serial value). |
| EOMONTH | High | Get the end-of-month date (serial value). |
| DATEVALUE | High | Converts a string date to a serial value. |
| TIMEVALUE | High | Converts a string time to a serial value. |
Function to retrieve a portion of a date/time or attached information.
| Function | Importance | Description |
|---|---|---|
| YEAR MONTH DAY HOUR MINUTE SECOND | High | Extract the year, month, date, time, minute, and second. |
| WEEKDAY | High | Get the day of the week corresponding to the date. |
| WEEKNUM ISOWEEKNUM | Middle | Get how many weeks in the year the date is. |
| YEARFRAC | Low | Get the percentage of the period between the two dates in a year. |
Function to calculate the difference between multiple dates.
| Function | Importance | Description |
|---|---|---|
| DAYS | High | Get the number of days between two dates. |
| NETWORKDAYS NETWORKDAYS.INTL | High | Retrieve the number of business days for the specified period. |
| DAYS360 | Low | Calculate the number of days between two dates, using a year as 360 days (12 months x 30 days). |