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?

I'm assuming the due date is in E2. This will return the difference between Today's date and the date in E2:

=DATEDIF(E2,TODAY(),"d")

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:

http://www.cpearson.com/excel/dated...

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

Ask Your Question

Weekly Poll

Do you think cloud computing will replacing gaming consoles?

Discuss in The Lounge

Poll History