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