Date Math Calculator

Date arithmetic: day differences, business days, age, leap years, day-of-week, add/subtract.

Community: Submitted by a user or imported; check the owner before granting accessOnlineNo sign-inGlobalFreeRead-only

What it can do

    What data it sees

    Do you need an account

    No: the server works without sign-in

    Date arithmetic: day differences, business days, age, leap years, day-of-week, add/subtract.

    Server tool list (6)

    Raw names from tools/list. Only developers need these.

    datemath_addAdds years/months/days to date. years/months are applied together with end-of-month clamping — e.g. 2026-01-31 + 1 month = 2026-02-28, not an overflowed 2026-03-03. days is then applied as plain calendar-day arithmetic.
    datemath_ageAge in whole years as of asOf (optional, defaults to the current UTC date). A Feb-29 birthDate is treated as falling on March 1 in a non-leap asOf year.
    datemath_businessdaysCounts days in [from, to] (inclusive on both ends) whose weekday is in weekdays (default mon-fri) and which aren't in holidays.
    datemath_dayofweekDay of the week for date: both the weekday name and its ISO 8601 weekday number (1=Monday..7=Sunday).
    datemath_diffDay difference between two YYYY-MM-DD dates: to minus from, in whole days. Negative if to is before from.
    datemath_leapyearChecks whether year is a leap year in the Gregorian calendar.