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: Calculates the number of whole work days between two given dates with a specified time offset relative to Coordinated Universal 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.
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( )
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)