How to return a month based on unusual month start dates and end dates?

[catkins (Crystal Atkins)]

Here is the thread I found pertaining to this exact problem.

Month() function/formula evaluates February 1st wrong, Month(February 1) => 1 but should be 2

The Formula column Month() function is supposed to evaluate to the number of the month of the year. Month(January 10) => 1 However, I get an invalid result for February 1st. I have not verified with all 364 other days of the year, but it would be nice if we could know that this evaluates correctly. [image]