Forum Discussion

Hongan1300's avatar
Hongan1300
Copper Contributor
May 01, 2023
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 ...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    May 01, 2023

    Hongan1300 

    Perhaps

    = IF(
    ISBLANK(E65),
    "",
    IF(
        TODAY() >= E65,
        "Expired",
        IF(
            AND(E65 > TODAY(), E65 <= (TODAY() + 30)),
            "Expiring",
            ""
        )
    )
)
Hongan1300's avatar
Hongan1300
Copper Contributor
May 01, 2023
That worked! Still unsure why mine didnt work, was it the spacing?
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 01, 2023

Hongan1300 

You had "" as second option in first IF(). With nested IF() second option is always next IF, except very last one.

Resources