If Then Formula Help!

Copper Contributor

I know it's basic. Years since I played in Excel. How do I correctly write a formula that states. =IF(cell = Todays Date, Amt Due, Amt Overdue)? I am sure its easy so thanks in advance for any help!

3 Replies

@Evesters 

You write that formula almost as you had it. The only missing ingredient I noticed was that you'll write "Todays Date" as TODAY()

Here's a good resource for you to use as you continue to play with Excel.

 

Thanks so much. This is how I had written it =IF(D16=TODAY(),AMT DUE,OVERDUE!)
Its giving me a #NAME error. I am typing out loud now but I think I know what I did wrong. If my date is not written in the same format as the TODAY() date produces would I get that error?

@Evesters 

 

If my date is not written in the same format as the TODAY() date produces would I get that error?

 

Your date in D16 needs to be a true Excel date, yes. Not a text field that "looks like" a date.