🧮 New Math functions

General
64

Method 1:

  • Use the Format Date column with the MMMM formatting option.

Method 2:

  • Add the month names of the year in a single column, one row per month
  • Use a Math column to determine the Month Index number from the date: Month(Date)-1
  • Use a Single Value column to fetch the month name from your list of months, using N from start where N is the month index.

Method 2 requires more effort, but it is more reliable and is guaranteed to work regardless of device/browser/regional date format variations.

3 Likes