Solved if statement for dates?

August 22, 2012 at 11:47:58
Specs: Windows 7
Basically im creating a spread sheet for my bills to keep track if they are paid late ect..

How do I write an If/Then statement in excel to change data to say late or current depending on the date? I have one field for the current date, a1, and a column of due dates, d4-d48 I want to know if the due dates are past todays current date to populate to say late or current in column I.

any ideas ?

See More: if statement for dates?

Report •

August 22, 2012 at 12:32:27
✔ Best Answer
Enter this in I4 and drag it down:


Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question