Function | Description | Text | Status |
|---|---|---|---|
DATE function | Returns the serial number of a particular date | Not started | |
DATEDIF function | Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age. | Not started | |
DATEVALUE function | Converts a date in the form of text to a serial number | Not started | |
DAY function | Converts a serial number to a day of the month | Not started | |
DAYS function | Returns the number of days between two dates | Not started | |
DAYS360 function | Calculates the number of days between two dates based on a 360-day year | Not started | |
EDATE function | Returns the serial number of the date that is the indicated number of months before or after the start date | Not started | |
EOMONTH function | Returns the serial number of the last day of the month before or after a specified number of months | Not started | |
HOUR function | Converts a serial number to an hour | Not started | |
ISOWEEKNUM function | Returns the number of the ISO week number of the year for a given date | Not started | |
MINUTE function | Converts a serial number to a minute | Not started | |
MONTH function | Converts a serial number to a month | Not started | |
NETWORKDAYS function | Returns the number of whole workdays between two dates | Not started | |
NETWORKDAYS.INTL function | Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days | Not started | |
NOW function | Returns the serial number of the current date and time | Not started | |
SECOND function | Converts a serial number to a second | Not started | |
TIME function | Returns the serial number of a particular time | Not started | |
TIMEVALUE function | Converts a time in the form of text to a serial number | Not started | |
TODAY function | Returns the serial number of today's date | Not started | |
WEEKDAY function | Converts a serial number to a day of the week | Not started | |
WEEKNUM function | Converts a serial number to a number representing where the week falls numerically with a year | Not started | |
WORKDAY function | Returns the serial number of the date before or after a specified number of workdays | Not started | |
WORKDAY.INTL function | 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 | Not started | |
YEAR function | Converts a serial number to a year | Not started | |
YEARFRAC function | Returns the year fraction representing the number of whole days between start_date and end_date | Not started |