Function | Description |
|---|---|
DATE | Returns the serial number for a date |
DATEDIF | Calculates the difference between the start and end dates in years, months, or days |
DATEVALUE | Converts a date formatted as text into a serial number |
DAY | Converts a serial number into a day of the month |
DAYS360 | Calculates the number of days between two dates based on a year with 360 days |
EDATE | Returns the serial number of the date that is the indicated number of months before or after the start date |
EOMONTH | Returns the serial number of the last day of the month that is the indicated number of months before or after the start date |
HOUR | Converts a serial number into an hour |
MINUTE | Converts a serial number into a minute |
MONTH | Converts a serial number into a month |
NETWORKDAY.INTL (2010) | Returns the number of workdays within a time interval, considering the weekend definition |
NETWORKDAYS | Returns the number of workdays between two dates |
NOW | |
SECOND | Converts a serial number into a second |
TIME | Returns the serial number for a time |
TIMEVALUE | Converts a time formatted as text into a serial number |
TODAY | Returns the serial number for the current date |
WEEKDAY | Converts a serial number into a week |
WEEKNUM | Returns a number indicating the week with the specified data |
WORKDAY | Returns the serial number of the date that is the indicated number of workdays before or after the start date |
WORKDAY.INTL (2010) | Returns the date as a continuous day in the year before or after a certain number of workdays, considering the weekend definition for the date |
YEAR | Converts a serial number into a year |
YEARFRAC | Returns the part of the year corresponding to the number of whole days between the start and end dates |