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 |
---|---|
35 | |
34 | |
26 | |
23 | |
18 |