Autonumber
Formula Reference
Description (from Formula Reference)
1
1
TODAY()

While similar to the NOW() function: TODAY() returns the current date (not the current time, if formatted, time will return 12:00am).


This function updates when the formula is recalculated, when a base is loaded, or otherwise roughly every 15 minutes when a base is open. If the base is closed, it will update approximately every hour only when the base has time-dependent automation triggers or actions, or sync dependencies.

2
2
NOW()

While similar to the TODAY() function, NOW() returns the current date AND time.

This function updates when the formula is recalculated, when a base is loaded, or otherwise roughly every 15 minutes when a base is open. If the base is closed, it will update approximately every hour only when the base has time-dependent automation triggers or actions, or sync dependencies.

3
3
SECOND()

Returns the second of a datetime as an integer between 0 and 59.

4
4
MINUTE()

Returns the minute of a datetime as an integer between 0 and 59.

5
5
HOUR()

Returns the hour of a datetime as a number between 0 (12:00am) and 23 (11:00pm).

6
6
DAY()

Returns the day of the month of a datetime in the form of a number between 1-31.

7
7
WEEKDAY()

Returns the day of the week as an integer between 0 (Sunday) and 6 (Saturday).

8
8
MONTH()

Returns the month of a datetime as a number between 1 (January) and 12 (December).

9
9
WEEKNUM()

Returns the week number in a year. You may optionally provide a second argument (either "Sunday" or "Monday") to start weeks on that day. If omitted, weeks start on Sunday by default. Example: WEEKNUM(TODAY(), "Monday")

10
10
YEAR()

Returns the four-digit year of a datetime.

Drag to adjust the number of frozen columns
Type (from Formula Reference)
Example Date (GMT)
Example Date 2 (GMT)
TODAY()
NOW()
SECOND([datetime])
MINUTE([datetime])
HOUR([datetime])
DAY([datetime])
WEEKDAY([datetime])
WORKDAY(startDate, numDays, [holidays])
Example number
Example text
WORKDAY() Example 2
MONTH([date])
WEEKNUM([date])
YEAR([date])
TONOW([date])
FROMNOW([date])
IS_BEFORE([date1], [date2])
IS_AFTER([date1], [date2])
IS_SAME([date1], [date2], [unit])
DATESTR([date])
TIMESTR([date/timestamp])
DATETIME_DIFF([date1], [date2], 'units')
DATETIME_FORMAT() - Example 2
DATETIME_DIFF() Example 2 - see formula!
WORKDAY_DIFF(startDate, endDate, [holidays])
WORKDAY_DIFF() Example 2 - see formula! copy
DATETIME_FORMAT([date], '[specified output format]')
DATETIME_PARSE(date string , ['input format'], ['locale'])
DATETIME_FORMAT() - Example 3
DATEADD([date], [#], 'units')
DATEADD()- Example 2
SET_LOCALE([date], [locale_modifier])
SET_LOCALE()- Example 2
SET_TIMEZONE([date], [tz_identifier])
SET_TIMEZONE()- Example 2
SET_TIMEZONE() w/ SET_LOCALE
Date and time functions
1999-01-01
01:00
2000-01-01
01:00
Date and time functions
1999-01-01
01:00
2000-01-01
01:00
Date and time functions
1999-01-01
01:00
2000-01-01
01:00
Date and time functions
1999-01-01
01:00
2000-01-01
00:30
Date and time functions
1999-01-01
01:00
2000-01-01
02:00
Date and time functions
1999-01-01
01:00
2000-01-19
01:00
Date and time functions
1999-01-01
01:00
2000-01-03
01:00
Date and time functions
1999-01-01
01:00
2000-07-05
01:00
Date and time functions
1999-01-17
01:00
2000-01-10
01:00
Date and time functions
1999-01-01
01:00
2005-01-01
01:00
25 records
Extensions

Alert

Lorem ipsum
Okay