Skip to main content
| Function | Syntax | Description | | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------- | | Month | month() | Returns the month of that cell the year where 1 is January, and 12 is December | | Quarter | quarter() | Returns the current quarter in the year | | Year | year() | Returns the current year | | Days in Month | daysInMonth() | Returns the number of days in the current month | | ____days in Month |

mondaysInMonth()
tuesdaysInMonth()
wednesdaysInMonth()
thursdaysInMonth()
fridaysInMonth()
saturdaysInMonth()
sundaysInMonth()

| Returns the number of a specific weekday (e.g: mondays) in the current month. | | Weekdays in Month | weekdaysInMonth() | Returns the number of weekdays in the current month (M-F). | | Months from Formula Start | monthsFromFormulaStart() | Returns the number of months since the current formula started (+1 every month). | | Quarters from Formula Start | quartersFromFormulaStart() | Returns the number of quarters since the current formula started (+1 every 3 months). | | Years from Formula Start | yearsFromFormulaStart() | Returns the number of years since the current formula started (+1 every 12 months). |