Functions Date and time Copy page Copy as markdownThe page as text, ready for a chat View as markdown/docs/functions/datetime-functions.md Ask Claude about this pageOpens Claude with this page's address Build, read and do arithmetic on dates and times. FunctionWhat it does DATE Creates date from year, month, day. DATEDIF Calculates difference between two dates. DATEVALUE Converts date text to serial number. DAY Returns day of month from date. DAYS Returns number of days between two dates. DAYS360 Returns days between dates on 360-day year. EDATE Returns date shifted by given months. EOMONTH Returns last day of month after offset. EPOCHTODATE Converts a unix timestamp to a date serial. HOUR Returns hour component of a time. ISOWEEKNUM Returns ISO week number of a date. MINUTE Returns minute component of a time. MONTH Returns month component of a date. NETWORKDAYS Returns business days between two dates. NETWORKDAYS.INTL Counts business days with custom weekend. NOW Returns current date and time. SECOND Returns second component of a time. TIME Creates time from hour, minute, second. TIMEVALUE Converts time text to serial number. TODAY Returns current date. WEEKDAY Returns day of week as a number. WEEKNUM Returns week number of a date. WORKDAY Returns date after given business days. WORKDAY.INTL Adds business days with custom weekend. YEAR Returns year component of a date. YEARFRAC Returns fraction of year between dates.
