Status | Function | Description |
|---|---|---|
Not started | CALENDAR | Returns a table with a single column named "Date" that contains a contiguous set of dates. |
Not started | CALENDARAUTO | Returns a table with a single column named "Date" that contains a contiguous set of dates. |
Not started | DATE | Returns the specified date in datetime format. |
Not started | DATEDIFF | Returns the number of interval boundaries between two dates. |
Not started | DATEVALUE | Converts a date in the form of text to a date in datetime format. |
Not started | DAY | Returns the day of the month, a number from 1 to 31. |
Not started | EDATE | Returns the date that is the indicated number of months before or after the start date. |
Not started | EOMONTH | Returns the date in datetime format of the last day of the month, before or after a specified number of months. |
Not started | HOUR | Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.). |
Not started | MINUTE | Returns the minute as a number from 0 to 59, given a date and time value. |
Not started | MONTH | Returns the month as a number from 1 (January) to 12 (December). |
Not started | NETWORKDAYS | Returns the number of whole workdays between two dates. |
Not started | NOW | Returns the current date and time in datetime format. |
Not started | QUARTER | Returns the quarter as a number from 1 to 4. |
Not started | SECOND | Returns the seconds of a time value, as a number from 0 to 59. |
Not started | TIME | Converts hours, minutes, and seconds given as numbers to a time in datetime format. |
Not started | TIMEVALUE | Converts a time in text format to a time in datetime format. |
Not started | TODAY | Returns the current date. |
Not started | UTCNOW | Returns the current UTC date and time |
Not started | UTCTODAY | Returns the current UTC date. |
Not started | WEEKDAY | Returns a number from 1 to 7 identifying the day of the week of a date. |
Not started | WEEKNUM | Returns the week number for the given date and year according to the return_type value. |
Not started | YEAR | Returns the year of a date as a four digit integer in the range 1900-9999. |
Not started | YEARFRAC | Calculates the fraction of the year represented by the number of whole days between two dates. |