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! Go to Solution.
Try:
([datetme-column] >= (EOMONTH(TODAY(), -1) + 1))
See also:
User | Count |
---|---|
39 | |
28 | |
24 | |
23 | |
13 |