Formula Playground
Copy base
Report abuse
🤖 All Functions and Operators
🚫 Common Errors
✏️Text function examples
❓Logical function examples
#️⃣ Numeric function examples
📆 Date and time function examples
🔎 REGEX function examples
✍️ Record function examples
[] Array function examples
Views
Extensions
Drag to adjust frozen columns
Alert
Lorem ipsum
Okay
12
Loaded
Autonumber
12
Formula Reference
Description (from Formula Reference)
Calculates the number of days between the current date and another date.
Type (from Formula Reference)
Date and time functions
Example Date (GMT)
1999-01-01
01:00
Example Date 2 (GMT)
2025-01-01
01:00
TODAY()
2/28/2025
12:00am
NOW()
2/28/2025
2:25am
SECOND([datetime])
0:43.000
MINUTE([datetime])
0
HOUR([datetime])
1
DAY([datetime])
1
WEEKDAY([datetime])
5
WORKDAY(startDate, numDays, [holidays])
1/8/1999
1:00am
Example number
5
Example text
1/1/2000
WORKDAY() Example 2
1/8/1999
1:00am
MONTH([date])
1
WEEKNUM([date])
1
YEAR([date])
1999
TONOW([date])
26 years
FROMNOW([date])
26 years
IS_BEFORE([date1], [date2])
1
IS_AFTER([date1], [date2])
0
IS_SAME([date1], [date2], [unit])
0
DATESTR([date])
1999-01-01
TIMESTR([date/timestamp])
01:00:00
DATETIME_DIFF([date1], [date2], 'units')
-9497
DATETIME_FORMAT() - Example 2
Friday 1 January 1999
DATETIME_DIFF() Example 2 - see formula!
-1356
WORKDAY_DIFF(startDate, endDate, [holidays])
6784
WORKDAY_DIFF() Example 2 - see formula! copy
6784
DATETIME_FORMAT([date], '[specified output format]')
01/1/1999
DATETIME_PARSE(date string , ['input format'], ['locale'])
1/1/2000
DATETIME_FORMAT() - Example 3
January 1, 1999 1:00 AM
DATEADD([date], [#], 'units')
1/6/1999
1:00am
DATEADD()- Example 2
2/5/1999
1:00am
SET_LOCALE([date], [locale_modifier])
viernes, 1 de enero de 1999 1:00
SET_LOCALE()- Example 2
1999년 1월 1일 금요일 오전 1시 0분
SET_TIMEZONE([date], [tz_identifier])
Fri, Jan 1, 1999 10:00 AM
SET_TIMEZONE()- Example 2
Thu, Dec 31, 1998 5:00 PM
SET_TIMEZONE() w/ SET_LOCALE
viernes, 1 de enero de 1999 10:00