CODEWITHSUNDEEP
excelexcel-formuladatatable
fanglies
fanglies

Reputation: 39

How to create an excel column that will flag dates that have passed or are upcoming

I have an column in a table that is full of dates. I am trying to create another column that will flag/label label each of the dates based on if they are upcoming or have already passed

This is what I have so far, and this same formula will go down the entire column (AW3,AW4,etc..) but I'm pretty sure I have some syntax errors

=
IF(ISBLANK(AW2),"NO DEADLINE",
IF(AW2="N/A"),"NO DEADLINE",
IF(AW2<=TODAY()),"DATE PASSED",
IF(AW2>TODAY()),"UPCOMING",))))

Upvotes: 0

Views: 383

Answers (1)

VvdL
VvdL

Reputation: 3210

Your parentheses are a bit off and there's a lone comma on the end. Using some tabs usually helps find these little mistakes:

=
IF(ISBLANK(AW2),"NO DEADLINE",
    IF(OR(ISNA(AW2), AW2 ="N/A"),"NO DEADLINE",
        IF(AW2<=TODAY(),"DATE PASSED",
            IF(AW2>TODAY(),"UPCOMING", "Exception"))))

Upvotes: 2

Related Questions