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 •


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

=IF(D4<$A$1,"Late","Current")

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


Report •
Related Solutions


Ask Question