Skip to main content

​
DATE

Creates a date from day, month, and year components. For more information, refer to the Google Sheets documentation. 
DATE(year, month, day)

DATE(2022, 12, 22)

​
DATEDIF

Finds the difference between two dates in specified units, such as days. For more information, refer to the Google Sheets documentation. 
DATEDIF(start_date, end_date, "unit")
Example 
DATEDIF(A1, B1, "M")

​
DAY

Returns the day of the month from a date. For more information, refer to the Google Sheets documentation. 
DAY(date)
Example 
DAY("2022-12-22")

​
DAYS

Finds the difference in days between two dates. Similar to DATEDIF. For more information, refer to the Google Sheets documentation. 
DAYS(start_date, end_date)
Example 
DAYS(A1, B1)DAYS(“2/28/2016”, “2/28/2017”)

​
EOMONTH

Returns the date of the last day of a month from a date or datetime value. This function takes two arguments:
  • date_value - The date from which to calculate the result
  • offset_months - The number of months before (negative) or after (positive) the date_value to consider
For more information, refer to the Google Sheets documentation. 
EOMONTH(date_value, offset_months)
Example 
EOMONTH("3/1/2024", 0)

​
HOUR

Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.). For more examples, refer to the Google Sheets documentation. 
HOUR(time)
Example 
HOUR(A1)HOUR("15:30")HOUR("20:49:59")

​
MINUTE

Returns the minute as a number from 0 to 59. For more examples, refer to the Google Sheets documentation. 
MINUTE(time)
Example 
MINUTE(A1)MINUTE("15:30")MINUTE("20:49:59")

​
NETWORKDAYS

Returns the number of whole working days between start_date and end_date. Weekend days are excluded. Note: While similar to Excel, Omni’s implementation of this function does not support the third holidays argument. 
NETWORKDAYS(start_date,end_date)
Date arguments used in this function must be specified using one of the following methods:
  • The DATE function, for example: DATE(2025, 1, 1)
  • As the result of another formula or function
  • As cell references (A1)
Example 
NETWORKDAYS(DATE(2025, 1, 1), DATE(2025, 2, 1))NETWORKDAYS(A1,B1)

​
NOW

Returns the current date and time as a date-time value. To create a date without the current time, use TODAY. For more information, refer to the Google Sheets documentation. 
NOW()
Example 
NOW()

​
SECOND

Returns the second from as a number from 0 to 59. For more examples, refer to the Google Sheets documentation. 
SECOND()
Example 
SECOND()

​
TODAY

Returns the current date as a date value. Does not accept arguments. To create a date with the current time, use NOW. For more examples, refer to the Google Sheets documentation. 
TODAY()
Example 
TODAY()

​
WEEKDAY

Returns the day of the week as a number from 1 to 7, where 1 is equal to Monday. 
WEEKDAY(date)
Example 
WEEKDAY("2022-12-22")

​
WEEKNUM

Returns a number representing the week of the year where the provided date falls. This function accepts two arguments:
  • date - The date for which to calculate the week number. Must be a date, a function returning a date type, or a number.
  • type - Optional. A number representing the day that a week starts on. Defaults to 1 (Sunday).
For more information, refer to the Google Sheets documentation. 
WEEKNUM(date, [type])
Example 
WEEKNUM("2022-12-22", 2)

​
YEAR

Returns the year from a date. For more information, refer to the Google Sheets documentation. 
YEAR(date)
Example 
YEAR("2022-12-22")