Test: check if a sequential "month" column skips a month

[newsroomdev]

Please read how to create a new test if you're interested in writing this test.

If a column is named month, or some variation, and contains an ordered series of month, check to see if it skips a month or more.

In the future we want to let users specify the length of gap in time they want to check against (i.e. show me if there's a gap longer than a trimester). For now we can test for gaps in immediately sequential months (i.e. January, February, March), and highlight the cells preceding and following the gap.

Methodology considerations:

• Should sort the column first in case the column is unordered
• Handle the following formats:
  • Full name, e.g. January
  • Abbreviation, e.g. Jan.
  • Number, e.g. 01 or 1