Months
List of each month from 2020 – 2030.
View all fields available in synced table
Formatted names
- Name (YYYY-MM MMM)
- Name (YYYY-MM MMMM)
- Name (MMMM YYYY)
- Name (YYYY-MM)
- Name non-primary (YYYY-MM MMM)
- Friendly name
Date range
- Start date
- End date
- Start date (Xd)
- End date (Xd)
Workdays (mon-fri)
- # workdays
- First workday date
- Last workday date
- % workdays through month
- # workdays remaining
- # workdays past
- # days
Relative to TODAY()
- Date status
- # months from this month
- # days until last day
- # days until last workday
- % days through month
- # years from this year
Link to months for comparison
- Previous YoY (YYYY-MM MMM)
- Previous month (YYYY-MM MMM)
- Next month (YYYY-MM MMM)
- Next YoY (YYYY-MM MMM)
Year
- Year (YYYY)
- Year (Number)
First and last workdays
Used for calculating work durations and utilisation/billability.
Customised primary fields
Select your own preferred date format.
Relative to TODAY()
Easily select key dates in automations; find "-1" meaning "last month".
Date ranges in UNIX days
Easily find date range overlaps by comparing dates as numbers.