How do I trigger an alert if the date in the End Date column is NOT the last day of the month?

Mjolly

Ray Lindstrom

@Mjolly,

As per Paul's comment on another post;

The easiest way to get the last day of the month is to get the first day of the next month and then subtract 1.

=IFERROR(DATE(YEAR([Date Column]@row), MONTH([Date Column]@row) + 1, 1), DATE(YEAR([Date Column]@row) + 1, 1, 1)) - 1

You can use that formula as a column formula in a helper column that you can keep hidden.

Hope that helps!

BRgds,
-Ray