Supported date & time functions

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(end_date, start_date)

Example

DAYS(“2/28/2017”, “2/28/2016”)

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")

MONTH

Returns the month (1-12) from a date.

For more information, refer to the Google Sheets documentation.

MONTH(date)

Example

MONTH("2022-12-22")

NETWORKDAYS

Returns the number of whole working days between start_date and end_date. Weekend days are excluded. Note: While similar to Excel, JustAsk’s implementation of this function does not support the third holidays argument.

NETWORKDAYS(start_date,end_date)

Note

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 as a number from 0 to 59.

For more examples, refer to the Google Sheets documentation.

SECOND(time)

Example

SECOND(A1)
SECOND("20:49:59")

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 Sunday. The optional return_type argument controls the numbering scheme.

WEEKDAY(date, [return_type])

Example

WEEKDAY("2022-12-22")
WEEKDAY("2022-12-22", 2)

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")