Date Functions

Learn how to use date function and variables on Pry.

Quarterly

Returns a value only on the first month of each quarter, otherwise returns zero. Passing 2 or 3 as the second argument will cause it to return a value only on the 2nd/3rd month of each quarter.

Month Number

Returns the month for the referenced column as a number between 1 and 12

Month Value

Returns the month and year for the referenced column in the format YYYY-MM.

Days in Month

Returns the number of days in the month of the referenced column.

Weekdays in Month

Returns the number of weekdays in the month of the referenced column.

Months from Today

Returns the number of months between the current date and the date of the cell being calculated.