Date and Time

date description returns the sequential serial number that represents a particular date example date(year, month, day) datediff description returns a formatted summary of difference between two dates example datediff(start date, end date) datetimenow description returns the current date and time in date/time format example datetimenow( ) datevalue description returns the serial number of the date value example datevalue(date text) day description returns the day of the month example day(serial number) days360 description returns the number of days between two dates using 360 day year example days360(start date, end date, method) hour description returns the hour from 0 to 23 example hour(serial number) minute description returns the minute from 0 to 59 example minute(serial number) month description returns the month from 1 to 12 example month(serial number) networkdays description calculates the number of whole work days between two given dates this includes all weekdays from monday to friday, but excludes a supplied list of holidays example networkdays(start date, end date, \[holidays]) networkdayswithoffset description the networkdayswithoffset function is used to calculate the number of whole work days between two given dates with a specified time offset relative to universal coordinated time (utc) this includes all weekdays from monday to friday, but excludes a supplied list of holidays the offset and holidays arguments cannot be provided as field references syntax networkdayswithoffset(start date, end date, offset, holidays) where start date the start of the period to find the working days end date the end of the period to find the working days offset the time offset expressed in hours and minutes relative to universal coordinated time (utc) holidays an optional argument, which specifies a comma separated list of dates that are not to be counted as working days remarks if any arguments are not provided in the correct format or the correct number of arguments is not provided, networkdayswithoffset returns the #value! error value example networkdayswithoffset(start date, end date, " 06 00", "7/4/2025,12/25/2025,1/1/2026") now description returns the current date and time example now( ) second description returns the second from 0 to 59 example second(serial number) time description returns serial number time example time(hour, minute, second) timevalue description returns the serial number time from a string example timevalue(time text) today description returns the current date example today( ) totaldays description returns the total number of days between two dates example totaldays(start date, end date) totalhours description returns the total number of hours between two dates example totalhours(start date, end date) totalminutes description returns the total number of minutes between two dates example totalminutes(start date, end date) weekday description returns the weekday from 1 to 7 example weekday(serial number,return type) year description returns the year from 1900 to 9999 example year(serial number)