For a full list of available formulas: https://formulajs.info/functions/
DATE
DATE
(year, month, day)
year
- The year component of the date.month
- The month component of the date.day
- The day component of the date.
DATEVALUE
(date_string)
date_string
- The string representing the date.
DAY
(date)
date
- The date from which to extract the day. Must be a reference to a cell containing a date, a function returning a date type, or a number.
DAYS
(end_date, start_date)
date
- The date from which to extract the day. Must be a reference to a cell containing a date, a function returning a date type, or a number.
TEXT
CONCATENATE
('text', ' ' , 'text')
Click values on the left to include in the formula
Text to be included must be placed between ' '
Use commas to separate each item
MATH
ROUND
(value, 2)
value - the number you want to round (numbers only, cannot use text fields)
2 - the number of decimal places you want to round to