Date formula in excel?

February 12, 2011 at 09:35:33
Specs: excel 2003
I am trying to create the following pivot table formula:
=IF"duedate(E2)>13,todays date(H2) true, # of days overdue<13=0, false)

What I am trying to calculate is if it was due on this date 12/10/10, and todays date is 2/12/11, how many days is the document overdue. I need to put this in a formula that excel can understand. Can anyone help?

See More: Date formula in excel?

Report •

February 12, 2011 at 13:27:02
I'm assuming the due date is in E2.

This will return the difference between Today's date and the date in E2:


Nested within an IF function, it could be used like this:

=IF(DATEDIF(E2,TODAY(),"d") >13, "The item is overdue", "The item is not overdue")

Note: The Help file for DATEDIF is missing in Excel 2003. If you want to learn more about it, look here:

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

Report •
Related Solutions

Ask Question