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.

11
11
TONOW()

Calculates the number of days between the current date and another date.

12
12
FROMNOW()

Calculates the number of days between the current date and another date.

13
13
IS_BEFORE()

Determines if [date1] is earlier than [date2]. Returns 1 if yes, 0 if no.

14
14
IS_AFTER()

Determines if [date1] is later than [date2]. Returns 1 if yes, 0 if no.

15
15
IS_SAME()

Compares two dates up to a unit and determines whether they are identical. Returns 1 if yes, 0 if no.

16
16
DATESTR()

Formats a datetime into a string (YYYY-MM-DD). 

17
17
TIMESTR()

Formats a datetime into a time-only string (HH:mm:ss).  

18
18
DATETIME_DIFF()

Returns the difference between datetimes in specified units. The difference between datetimes is determined by subtracting [date2] from [date1]. This means that if [date2] is later than [date1], the resulting value will be negative. 

Default units are seconds. (See list of unit specifiers here.)

Note: The DATETIME_DIFF() formula will return whole integers for any unit specifier.

19
19
WORKDAY()

Returns a date that is numDays working days after startDate. Working days exclude weekends and an optional list of holidays, formatted as a comma-separated string of ISO-formatted dates.

20
20
WORKDAY_DIFF()

Counts the number of working days between startDate and endDate. Working days exclude weekends and an optional list of holidays, formatted as a comma-separated string of ISO-formatted dates.

21
21
DATETIME_PARSE()

Interprets a text string as a structured date, with optional input format and locale parameters. The output format will always be formatted 'M/D/YYYY h:mm a'.

22
22
DATETIME_FORMAT()

Formats a datetime into a specified string. For an explanation of how to use this function with date fields, click here. For a list of supported format specifiers, please click here.

23
23
DATEADD()

Adds specified "count" units to a datetime. (See list of shared unit specifiers here. For this function we recommend using the full unit specifier for your desired unit.) 

24
24
SET_LOCALE()

Sets a specific locale for a datetime. Must be used in conjunction with DATETIME_FORMAT. A list of supported locale modifiers can be found here.

25
25
SET_TIMEZONE()

Sets a specific timezone for a datetime. Must be used in conjunction with DATETIME_FORMAT. A list of supported timezone identifiers can be found here.

Cannot adjust frozen columns; click to learn more or reset
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
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
1
5
1/4/1999
1:00am
1
1/1/2000
1/4/1999
1:00am
1
1
1999
26 years
26 years
1
0
0
1999-01-01
01:00:00
-365
Friday 1 January 1999
-52
261
261
01/1/1999
1/1/2000
January 1, 1999 1:00 AM
1/2/1999
1:00am
1/8/1999
1:00am
viernes, 1 de enero de 1999 1:00
1999년 1월 1일 금요일 오전 1시 0분
Fri, Jan 1, 1999 10:00 AM
Thu, Dec 31, 1998 5:00 PM
viernes, 1 de enero de 1999 10:00
Date and time functions
1999-01-01
01:00
2000-01-01
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
1
5
1/4/1999
1:00am
1
1/1/2000
1/4/1999
1:00am
1
1
1999
26 years
26 years
1
0
0
1999-01-01
01:00:00
-365
Friday 1 January 1999
-52
261
261
01/1/1999
1/1/2000
January 1, 1999 1:00 AM
1/2/1999
1:00am
1/8/1999
1:00am
viernes, 1 de enero de 1999 1:00
1999년 1월 1일 금요일 오전 1시 0분
Fri, Jan 1, 1999 10:00 AM
Thu, Dec 31, 1998 5:00 PM
viernes, 1 de enero de 1999 10:00
Date and time functions
1999-01-01
01:00
2000-01-01
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
1
5
1/4/1999
1:00am
1
1/1/2000
1/4/1999
1:00am
1
1
1999
26 years
26 years
1
0
0
1999-01-01
01:00:00
-365
Friday 1 January 1999
-52
261
261
01/1/1999
1/1/2000
January 1, 1999 1:00 AM
1/2/1999
1:00am
1/8/1999
1:00am
viernes, 1 de enero de 1999 1:00
1999년 1월 1일 금요일 오전 1시 0분
Fri, Jan 1, 1999 10:00 AM
Thu, Dec 31, 1998 5:00 PM
viernes, 1 de enero de 1999 10:00
Date and time functions
1999-01-01
01:00
2000-01-01
00:30
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
1
5
1/4/1999
1:00am
1
1/1/2000
1/4/1999
1:00am
1
1
1999
26 years
26 years
1
0
0
1999-01-01
01:00:00
-364
Friday 1 January 1999
-52
261
261
01/1/1999
1/1/2000
January 1, 1999 1:00 AM
1/2/1999
1:00am
1/8/1999
1:00am
viernes, 1 de enero de 1999 1:00
1999년 1월 1일 금요일 오전 1시 0분
Fri, Jan 1, 1999 10:00 AM
Thu, Dec 31, 1998 5:00 PM
viernes, 1 de enero de 1999 10:00
Date and time functions
1999-01-01
01:00
2000-01-01
02:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
1
5
1/4/1999
1:00am
1
1/1/2000
1/4/1999
1:00am
1
1
1999
26 years
26 years
1
0
0
1999-01-01
01:00:00
-365
Friday 1 January 1999
-52
261
261
01/1/1999
1/1/2000
January 1, 1999 1:00 AM
1/2/1999
1:00am
1/8/1999
1:00am
viernes, 1 de enero de 1999 1:00
1999년 1월 1일 금요일 오전 1시 0분
Fri, Jan 1, 1999 10:00 AM
Thu, Dec 31, 1998 5:00 PM
viernes, 1 de enero de 1999 10:00
Date and time functions
1999-01-01
01:00
2000-01-19
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
1
5
1/4/1999
1:00am
1
1/1/2000
1/4/1999
1:00am
1
1
1999
26 years
26 years
1
0
0
1999-01-01
01:00:00
-383
Friday 1 January 1999
-54
274
274
01/1/1999
1/1/2000
January 1, 1999 1:00 AM
1/2/1999
1:00am
1/8/1999
1:00am
viernes, 1 de enero de 1999 1:00
1999년 1월 1일 금요일 오전 1시 0분
Fri, Jan 1, 1999 10:00 AM
Thu, Dec 31, 1998 5:00 PM
viernes, 1 de enero de 1999 10:00
Date and time functions
1999-01-01
01:00
2000-01-03
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
1
5
1/4/1999
1:00am
1
1/1/2000
1/4/1999
1:00am
1
1
1999
26 years
26 years
1
0
0
1999-01-01
01:00:00
-367
Friday 1 January 1999
-52
262
262
01/1/1999
1/1/2000
January 1, 1999 1:00 AM
1/2/1999
1:00am
1/8/1999
1:00am
viernes, 1 de enero de 1999 1:00
1999년 1월 1일 금요일 오전 1시 0분
Fri, Jan 1, 1999 10:00 AM
Thu, Dec 31, 1998 5:00 PM
viernes, 1 de enero de 1999 10:00
Date and time functions
1999-01-01
01:00
2000-07-05
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
1
5
1/8/1999
1:00am
5
1/1/2000
1/8/1999
1:00am
1
1
1999
26 years
26 years
1
0
0
1999-01-01
01:00:00
-551
Friday 1 January 1999
-78
394
394
01/1/1999
1/1/2000
January 1, 1999 1:00 AM
1/6/1999
1:00am
2/5/1999
1:00am
viernes, 1 de enero de 1999 1:00
1999년 1월 1일 금요일 오전 1시 0분
Fri, Jan 1, 1999 10:00 AM
Thu, Dec 31, 1998 5:00 PM
viernes, 1 de enero de 1999 10:00
Date and time functions
1999-01-17
01:00
2000-01-10
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
17
0
1/22/1999
1:00am
5
1/1/2000
1/22/1999
1:00am
1
4
1999
26 years
26 years
1
0
0
1999-01-17
01:00:00
-358
Sunday 17 January 1999
-51
256
256
01/17/1999
1/1/2000
January 17, 1999 1:00 AM
1/22/1999
1:00am
2/21/1999
1:00am
domingo, 17 de enero de 1999 1:00
1999년 1월 17일 일요일 오전 1시 0분
Sun, Jan 17, 1999 10:00 AM
Sat, Jan 16, 1999 5:00 PM
domingo, 17 de enero de 1999 10:00
Date and time functions
1999-01-01
01:00
2005-01-01
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
1
5
1/8/1999
1:00am
5
1/1/2000
1/8/1999
1:00am
1
1
1999
26 years
26 years
1
0
0
1999-01-01
01:00:00
-2192
Friday 1 January 1999
-313
1566
1566
01/1/1999
1/1/2000
January 1, 1999 1:00 AM
1/6/1999
1:00am
2/5/1999
1:00am
viernes, 1 de enero de 1999 1:00
1999년 1월 1일 금요일 오전 1시 0분
Fri, Jan 1, 1999 10:00 AM
Thu, Dec 31, 1998 5:00 PM
viernes, 1 de enero de 1999 10:00
Date and time functions
1999-01-01
01:00
2050-01-01
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
1
5
1/8/1999
1:00am
5
1/1/2000
1/8/1999
1:00am
1
1
1999
26 years
26 years
1
0
0
1999-01-01
01:00:00
-18628
Friday 1 January 1999
-2661
13306
13306
01/1/1999
1/1/2000
January 1, 1999 1:00 AM
1/6/1999
1:00am
2/5/1999
1:00am
viernes, 1 de enero de 1999 1:00
1999년 1월 1일 금요일 오전 1시 0분
Fri, Jan 1, 1999 10:00 AM
Thu, Dec 31, 1998 5:00 PM
viernes, 1 de enero de 1999 10:00
Date and time functions
1999-01-01
01:00
2025-01-01
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
1
5
1/8/1999
1:00am
5
1/1/2000
1/8/1999
1:00am
1
1
1999
26 years
26 years
1
0
0
1999-01-01
01:00:00
-9497
Friday 1 January 1999
-1356
6784
6784
01/1/1999
1/1/2000
January 1, 1999 1:00 AM
1/6/1999
1:00am
2/5/1999
1:00am
viernes, 1 de enero de 1999 1:00
1999년 1월 1일 금요일 오전 1시 0분
Fri, Jan 1, 1999 10:00 AM
Thu, Dec 31, 1998 5:00 PM
viernes, 1 de enero de 1999 10:00
Date and time functions
2025-01-01
01:00
2000-01-01
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
1
3
1/8/2025
1:00am
5
1/1/2000
1/8/2025
1:00am
1
1
2025
2 months
2 months
0
1
0
2025-01-01
01:00:00
9132
Wednesday 1 January 2025
1304
-6523
-6523
01/1/2025
1/1/2000
January 1, 2025 1:00 AM
1/6/2025
1:00am
2/5/2025
1:00am
miércoles, 1 de enero de 2025 1:00
2025년 1월 1일 수요일 오전 1시 0분
Wed, Jan 1, 2025 10:00 AM
Tue, Dec 31, 2024 5:00 PM
miércoles, 1 de enero de 2025 10:00
Date and time functions
2025-01-01
01:00
2000-01-01
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
1
3
1/8/2025
1:00am
5
1/1/2000
1/8/2025
1:00am
1
1
2025
2 months
2 months
0
1
0
2025-01-01
01:00:00
9132
Wednesday 1 January 2025
1304
-6523
-6523
01/1/2025
1/1/2000
January 1, 2025 1:00 AM
1/6/2025
1:00am
2/5/2025
1:00am
miércoles, 1 de enero de 2025 1:00
2025년 1월 1일 수요일 오전 1시 0분
Wed, Jan 1, 2025 10:00 AM
Tue, Dec 31, 2024 5:00 PM
miércoles, 1 de enero de 2025 10:00
Date and time functions
2000-01-01
01:00
2000-01-01
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
1
6
1/7/2000
1:00am
5
1/1/2000
1/7/2000
1:00am
1
1
2000
25 years
25 years
0
0
1
2000-01-01
01:00:00
0
Saturday 1 January 2000
0
0
0
01/1/2000
1/1/2000
January 1, 2000 1:00 AM
1/6/2000
1:00am
2/5/2000
1:00am
sábado, 1 de enero de 2000 1:00
2000년 1월 1일 토요일 오전 1시 0분
Sat, Jan 1, 2000 10:00 AM
Fri, Dec 31, 1999 5:00 PM
sábado, 1 de enero de 2000 10:00
Text functions
2000-01-19
01:00
2000-01-01
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
19
3
1/26/2000
1:00am
5
1/1/2000
1/26/2000
1:00am
1
4
2000
25 years
25 years
0
1
0
2000-01-19
01:00:00
18
Wednesday 19 January 2000
2
-13
-13
01/19/2000
1/1/2000
January 19, 2000 1:00 AM
1/24/2000
1:00am
2/23/2000
1:00am
miércoles, 19 de enero de 2000 1:00
2000년 1월 19일 수요일 오전 1시 0분
Wed, Jan 19, 2000 10:00 AM
Tue, Jan 18, 2000 5:00 PM
miércoles, 19 de enero de 2000 10:00
Date and time functions
2000-01-01
06:30
2000-01-01
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
30
6
1
6
1/7/2000
6:30am
5
1/1/2000
1/7/2000
6:30am
1
1
2000
25 years
25 years
0
1
0
2000-01-01
06:30:00
0
Saturday 1 January 2000
0
0
0
01/1/2000
1/1/2000
January 1, 2000 6:30 AM
1/6/2000
6:30am
2/5/2000
6:30am
sábado, 1 de enero de 2000 6:30
2000년 1월 1일 토요일 오전 6시 30분
Sat, Jan 1, 2000 3:30 PM
Fri, Dec 31, 1999 10:30 PM
sábado, 1 de enero de 2000 15:30
Date and time functions
2000-01-02
01:00
2000-02-06
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
2
0
1/7/2000
1:00am
5
1/1/2000
1/7/2000
1:00am
1
2
2000
25 years
25 years
1
0
0
2000-01-02
01:00:00
-35
Sunday 2 January 2000
-5
25
25
01/2/2000
1/1/2000
January 2, 2000 1:00 AM
1/7/2000
1:00am
2/6/2000
1:00am
domingo, 2 de enero de 2000 1:00
2000년 1월 2일 일요일 오전 1시 0분
Sun, Jan 2, 2000 10:00 AM
Sat, Jan 1, 2000 5:00 PM
domingo, 2 de enero de 2000 10:00
Date and time functions
2000-01-01
01:00
2000-01-01
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
1
6
1/7/2000
1:00am
5
1/3/2000, 1/4/2000
1/11/2000
1:00am
1
1
2000
25 years
25 years
0
0
1
2000-01-01
01:00:00
0
Saturday 1 January 2000
0
0
0
01/1/2000
1/3/2000
January 1, 2000 1:00 AM
1/6/2000
1:00am
2/5/2000
1:00am
sábado, 1 de enero de 2000 1:00
2000년 1월 1일 토요일 오전 1시 0분
Sat, Jan 1, 2000 10:00 AM
Fri, Dec 31, 1999 5:00 PM
sábado, 1 de enero de 2000 10:00
Date and time functions
2000-02-01
01:00
2000-02-26
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
1
2
2/8/2000
1:00am
5
2/3/2000, 2/4/2000
2/10/2000
1:00am
2
6
2000
25 years
25 years
1
0
0
2000-02-01
01:00:00
-25
Tuesday 1 February 2000
-3
19
17
02/1/2000
2/3/2000
February 1, 2000 1:00 AM
2/6/2000
1:00am
3/7/2000
1:00am
martes, 1 de febrero de 2000 1:00
2000년 2월 1일 화요일 오전 1시 0분
Tue, Feb 1, 2000 10:00 AM
Mon, Jan 31, 2000 5:00 PM
martes, 1 de febrero de 2000 10:00
Date and time functions
2000-01-01
01:00
2000-01-01
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
1
6
1/7/2000
1:00am
5
5 13 1997
1/7/2000
1:00am
1
1
2000
25 years
25 years
0
0
1
2000-01-01
01:00:00
0
Saturday 1 January 2000
0
0
0
01/1/2000
5/13/1997
January 1, 2000 1:00 AM
1/6/2000
1:00am
2/5/2000
1:00am
sábado, 1 de enero de 2000 1:00
2000년 1월 1일 토요일 오전 1시 0분
Sat, Jan 1, 2000 10:00 AM
Fri, Dec 31, 1999 5:00 PM
sábado, 1 de enero de 2000 10:00
Date and time functions
2005-02-05
10:30
2000-01-01
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
30
10
5
6
2/11/2005
10:30am
5
5 13 1997
2/11/2005
10:30am
2
6
2005
20 years
20 years
0
1
0
2005-02-05
10:30:00
1862
Saturday 5 February 2005
266
-1330
-1330
02/5/2005
5/13/1997
February 5, 2005 10:30 AM
2/10/2005
10:30am
3/12/2005
10:30am
sábado, 5 de febrero de 2005 10:30
2005년 2월 5일 토요일 오전 10시 30분
Sat, Feb 5, 2005 7:30 PM
Sat, Feb 5, 2005 2:30 AM
sábado, 5 de febrero de 2005 19:30
Date and time functions
2000-01-01
01:00
2000-01-01
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
1
6
1/7/2000
1:00am
5
#ERROR
1
1
2000
25 years
25 years
0
0
1
2000-01-01
01:00:00
0
Saturday 1 January 2000
0
0
#ERROR
01/1/2000
#ERROR!
January 1, 2000 1:00 AM
1/6/2000
1:00am
2/5/2000
1:00am
sábado, 1 de enero de 2000 1:00
2000년 1월 1일 토요일 오전 1시 0분
Sat, Jan 1, 2000 10:00 AM
Fri, Dec 31, 1999 5:00 PM
sábado, 1 de enero de 2000 10:00
Date and time functions
2000-01-01
01:00
2000-01-01
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
1
1
6
1/7/2000
1:00am
5
#ERROR
1
1
2000
25 years
25 years
0
0
1
2000-01-01
01:00:00
0
Saturday 1 January 2000
0
0
#ERROR
01/1/2000
#ERROR!
January 1, 2000 1:00 AM
1/6/2000
1:00am
2/5/2000
1:00am
sábado, 1 de enero de 2000 1:00
2000년 1월 1일 토요일 오전 1시 0분
Sat, Jan 1, 2000 10:00 AM
Fri, Dec 31, 1999 5:00 PM
sábado, 1 de enero de 2000 10:00
Date and time functions
2015-01-01
12:00
2000-01-01
01:00
2/24/2025
12:00am
2/24/2025
8:07pm
0:49.000
0
12
1
4
1/8/2015
12:00pm
5
#ERROR
1
1
2015
10 years
10 years
0
1
0
2015-01-01
12:00:00
5479
Thursday 1 January 2015
782
-3914
#ERROR
01/1/2015
#ERROR!
January 1, 2015 12:00 PM
1/6/2015
12:00pm
2/5/2015
12:00pm
jueves, 1 de enero de 2015 12:00
2015년 1월 1일 목요일 오후 12시 0분
Thu, Jan 1, 2015 9:00 PM
Thu, Jan 1, 2015 4:00 AM
jueves, 1 de enero de 2015 21:00
25 records
Extensions

Alert

Lorem ipsum
Okay