IF formula

[daniela.rodannova]

Hi, I have used IF formula in status column but it is not working. I tried to change the formatting of date but nothing helped. Can you plsease help me? I attached an excel file. Thank you.

[Sam Capricci]

Your date in A3 is text and not a number (formate as a date)
reenter it as a date and you should be fine.

[daniela.rodannova]

I did, but I am still not getting overdue result.

[Sam Capricci]

it worked fine for me when I changed it, here it is attached.

[Sam Capricci]

The way you can tell it is a "date" but actually text which looks like a date is enter this formula in an empty cell =ISNUMBER(A3) If it returns FALSE then it is text and not a number.
Remember, dates are numbers that excel formats to look like a date. 01/14/2021 is simply 44210 as a number - the number of days since 1/1/1900 through that date.

[daniela.rodannova]

How exactly did you do it? You first changed formatting to date and then coppied the date there again?

[Sam Capricci]

I just clicked in the cell and retyped 1/14/21 and hit enter and it corrected.
If you have a batch of cells that are text and you want them as number, highlight the area (column or group of cells) and go to the data tab then text to columns then just hit finish and they'll all covert to numbers.

[daniela.rodannova]

Thank you! But what do I do wrong that when I change the cell to date formatting and it still is not a date and the is number function is on FALSE.

[daniela.rodannova]

Ok, thank you very much for your help!

[Sam Capricci]

highlight the area you want and format to general, that usually takes care of the formatting you'll need.
you can try the hint I gave you in post #7.

[Sam Capricci]

I was still typing when you posted again, so if that takes care of your issue please don't forget to mark the post as solved using the thread tools dropdown at the top of the post.