Oct 14 2022 11:58 AM
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!
Oct 14 2022 12:23 PM
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.
Oct 14 2022 12:33 PM
Oct 14 2022 12:50 PM
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.