Overdue or Not

[dragonmouse]

Should be easy. Column "A" has a DUE DATE. Based on the date as of TODAY(). Is it late or not? I can deal with simple true or false. It's just not working.

 

[dave2018]

Edit: Mistake, it wasn't letting me type normally in this post...

 

[dave2018]

in B1:

(if today is counted as not late, enter this: )
=IF(A1<=TODAY(),"Not Late","Late")

if today is late then take out the = sign before TODAY in the formula<today(),"not late","late")<today(),"not="" late","late")<="" html=""></today(),"not>

 

[dragonmouse]

The formula above is returning "Not Late" for those items that do not have an entry as in cell A1. Everything that has an entry returns LATE whether is it or not using formula =IF(A1<=TODAY(),"Not Late","Late")


A ................... B
1 BLANK.......... Not Late
2 25-JUL-18......LATE
3 1-JUN-18.......LATE
4 19-JUN-18.....LATE
5 30-JUL-18......LATE

 

[dave2018]

works for me.

btw, this addition takes care ofblanks:

=IF(A1<>"",IF(A1<=TODAY(),"Not Late","Late"),"")

but the rest works for me...

is column a formatted as date or text?

 

[dragonmouse]

I think I see what's been happening. For whatever reason when it transferred over to EXCEL from my database it changed my dates to TEXT. I tried formatting it but it's not working. So now I have a new problem to figure out. But thank you. I think this will work when I figure out how to clean up the format.

 

[dragonmouse]

This worked, not as fancy...just returns a true or false but I can live with it. Thank you so much:

=TODAY()-A1>0

 

[dragonmouse]

Too late to edit but this works too to get rid of blanks, I guess there's so many ways to do this, I wish I understood why:

=IF(ISBLANK(A1),"",TODAY()-A1>0)

 

[dave2018]

This worked, not as fancy...just returns a true or false but I can live with it. Thank you so much:

=TODAY()-A1>0

Actually, there are a million ways to do everything...

but this method is not as efficient, partly because someone reading this formula: =TODAY()-A1>0 is harder to read after-the-fact, while =A1<=TODAY() is more used and more straigtfoward, (meaning that if you read from left to right, you can see the question being asked (formula in red): Is A1 less than (<) or equal to (=) TODAY()?

all the best

 

[dragonmouse]

Thank you so much