Forum Discussion
Solved
How to write date validation formula
I am trying to compare the date inside of Column E to todays date. 1. If today's date is greater than date in Column E then Expired 2. If the date within Column E is within 30 days of Today's date ...
Perhaps
= IF( ISBLANK(E65), "", IF( TODAY() >= E65, "Expired", IF( AND(E65 > TODAY(), E65 <= (TODAY() + 30)), "Expiring", "" ) ) )
Perhaps
= IF(
ISBLANK(E65),
"",
IF(
TODAY() >= E65,
"Expired",
IF(
AND(E65 > TODAY(), E65 <= (TODAY() + 30)),
"Expiring",
""
)
)
)- That worked! Still unsure why mine didnt work, was it the spacing?
You had "" as second option in first IF(). With nested IF() second option is always next IF, except very last one.
