Forum Discussion

Copper Contributor

Oct 14, 2022

If Then Formula Help!

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!

excel

Formulas and Functions

training

mathetes

Gold Contributor

Oct 14, 2022

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.

Evesters
Copper Contributor
Oct 14, 2022
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?
- mathetes
  Gold Contributor
  Oct 14, 2022
  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.