Forum Discussion

Evesters's avatar
Evesters
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

3 Replies

Sort By
  • mathetes's avatar
    mathetes
    Silver 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's avatar
      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's avatar
        mathetes
        Silver 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.

Resources