datetime functions
build, read and do arithmetic on dates and times.
| function | signature | what it does | tests |
|---|---|---|---|
| DATE | DATE(year, month, day) | creates date from year, month, day | 18 |
| DATEDIF | DATEDIF(start_date, end_date, unit) | calculates difference between two dates | — |
| DATEVALUE | DATEVALUE(date_text) | converts date text to serial number | — |
| DAY | DAY(serial_number) | returns day of month from date | 1 |
| DAYS | DAYS(end_date, start_date) | returns number of days between two dates | 1 |
| DAYS360 | DAYS360(start_date, end_date, [method]) | returns days between dates on 360-day year | — |
| EDATE | EDATE(start_date, months) | returns date shifted by given months | — |
| EOMONTH | EOMONTH(start_date, months) | returns last day of month after offset | — |
| HOUR | HOUR(serial_number) | returns hour component of a time | — |
| ISOWEEKNUM | ISOWEEKNUM(date) | returns ISO week number of a date | — |
| MINUTE | MINUTE(serial_number) | returns minute component of a time | — |
| MONTH | MONTH(serial_number) | returns month component of a date | — |
| NETWORKDAYS | NETWORKDAYS(start_date, end_date, [holidays]) | returns business days between two dates | 11 |
| NETWORKDAYS.INTL | NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) | counts business days with custom weekend | 9 |
| NOW | NOW() | returns current date and time | — |
| SECOND | SECOND(serial_number) | returns second component of a time | — |
| TIME | TIME(hour, minute, second) | creates time from hour, minute, second | — |
| TIMEVALUE | TIMEVALUE(time_text) | converts time text to serial number | — |
| TODAY | TODAY() | returns current date | — |
| WEEKDAY | WEEKDAY(serial_number, [return_type]) | returns day of week as a number | — |
| WEEKNUM | WEEKNUM(serial_number, [return_type]) | returns week number of a date | — |
| WORKDAY | WORKDAY(start_date, days, [holidays]) | returns date after given business days | 7 |
| WORKDAY.INTL | WORKDAY.INTL(start_date, days, [weekend], [holidays]) | adds business days with custom weekend | 6 |
| YEAR | YEAR(serial_number) | returns year component of a date | — |
| YEARFRAC | YEARFRAC(start_date, end_date, [basis]) | returns fraction of year between dates | — |