Valid if date: only this and coming months

Hi there, I’m looking for a Valid If expression in a Date Type column that gives an error when the given date lays in an earlier month as the month of today.

Example: Today is February 2, 2021.
Valid input: February 1, 2021 - May 28, 2021
Not valid: January 15, 2021 - August 20, 2020 etc.

Can’t figure it out, hope you guys can help me!

Solved Solved
0 1 866
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

Try:

([datetme-column] >= (EOMONTH(TODAY(), -1) + 1))

See also:

View solution in original post

1 REPLY 1

Steve
Platinum 4
Platinum 4

Try:

([datetme-column] >= (EOMONTH(TODAY(), -1) + 1))

See also:

Top Labels in this Space