Skip to main content

​
DATE

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

​
DATEDIF

Finds the difference between two dates in specified units, such as days. For more information, refer to the Google Sheets documentation.
Example

​
DAY

Returns the day of the month from a date. For more information, refer to the Google Sheets documentation.
Example

​
DAYS

Finds the difference in days between two dates. Similar to DATEDIF. For more information, refer to the Google Sheets documentation.
Example

​
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.
Example

​
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.
Example

​
MINUTE

Returns the minute as a number from 0 to 59. For more examples, refer to the Google Sheets documentation.
Example

​
MONTH

Returns the month (1-12) from a date. For more information, refer to the Google Sheets documentation.
Example

​
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.
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

​
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.
Example

​
SECOND

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

​
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.
Example

​
WEEKDAY

Returns the day of the week as a number from 1 to 7, where 1 is equal to Sunday. The optional return_type argument controls the numbering scheme.
Example

​
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.
Example

​
YEAR

Returns the year from a date. For more information, refer to the Google Sheets documentation.
Example