Hi I'm trying this to format a column of date to turn red if it's going to be two months from todays date It tried this
[Reg. Expiry] >= EOMONTH(TODAY(), 1) + DAY(TODAY())
But it also change the date past two months, If any have suggestions for help I appreciate it thank you
Welcome to the community!
Try this:
AND(
MONTH([Reg. Expiry]) >= MONTH(TODAY()) + 2,
DAY([Reg. Expiry]) >= DAY(TODAY())
)
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |