Date Formulas
Use TODAY, date offsets, date-part helpers, and weekday counters such as MONDAY(start,end) in TableStudio formulas.
TableStudio supports lightweight date formulas for schedules, codes, deadlines, and date-based text patterns. The most direct helper is =TODAY or =TODAY(), which returns the current date. Related helpers include M, MM, D, DD, YEAR, YYYY, YY, MONTH, DAY, and weekday counters such as MONDAY(start,end) through SUNDAY(start,end). Date results are shown using the active file date format from File > File Settings, including dd-mm-yyyy, dd.mm.yyyy, yyyy-mm-dd, or mm/dd/yyyy.
You can add or subtract days from a real date with expressions such as =TODAY+5, =TODAY-3, =A1+5, or =A1-3. If the left-hand side is actually a date, TableStudio returns a shifted date. If it is plain text or a normal number, TableStudio keeps normal numeric/text formula behavior instead of forcing date math.
Date-part helpers are available with an optional date argument. MM(date) returns the month with a leading zero, M(date) returns the month without the leading zero, DD(date) and D(date) do the same for the day, YYYY(date) and YEAR(date) return the full year, and YY(date) returns the last two digits of the year. MONTH(date) returns the month name and DAY(date) returns the day name. If the argument is omitted, the current date is used, so helpers such as =MM(), =YY(), =MONTH(), and =DAY() are valid.
Weekday counters are available for each day of the week. MONDAY(start,end) counts Mondays between 2 dates, TUESDAY(start,end) counts Tuesdays, and so on through SUNDAY(start,end). These counters are inclusive of both the start and end date, so =SATURDAY(A1,B1)+SUNDAY(A1,B1) can be used directly in a derived formula to count all weekends inside a period.
These helpers also work well inside larger formulas. For example, ="DOC-"+YY(TODAY)+"-"+MM(TODAY) can generate a code with the current year and month, while a date column can use formulas like =A1+5 without opening the date picker first. Related: Column Type: Date, ROUND / ROUNDUP / ROUNDDOWN, SUM.
Function
TODAY TODAY() TODAY+N MM(date) M(date) DD(date) D(date) YYYY(date) YY(date) YEAR(date) MONTH(date) DAY(date) MONDAY(start,end) TUESDAY(start,end) WEDNESDAY(start,end) THURSDAY(start,end) FRIDAY(start,end) SATURDAY(start,end) SUNDAY(start,end)
Parameters
- date — Optional date source. This can be a date cell reference such as
A1, a cross-sheet reference such asSH2(B4), orTODAY. If omitted, the current date is used in the single-date helpers. - N — Whole-day offset added to or subtracted from a date, for example
TODAY+5orA1-3. - start, end — Start and end dates used by the weekday counters such as
MONDAY(start,end)orSATURDAY(start,end). The count is inclusive of both ends.
Returns
Returns either a date, a numeric date part, or a month/day name depending on the helper used. Date results are displayed using the active file date format.
=TODAY returns the current date using the file display format.
=TODAY+5 returns the date 5 days after today.
=MM(TODAY) returns the current month with two digits.
Current date and offset
Use TODAY directly for the current date or add days for a deadline calculation.
Date-part helpers
Extract code-friendly values or readable names from a date cell or the current date.
Count weekends between 2 dates
Weekday counters are inclusive of both dates and can be combined inside larger formulas.
Enable JavaScript to use reading progress and usefulness ratings.