Number of days past due

R

rrupp

I have set up a formula, in Excel 2003, for days past due. So the formula is
calculated based on numbers from columns and then I figured out part of what
I want to do but not all of it.

Example:

=IF(F3<TODAY(),"PM Due","")
Right now it either says PM Due or it's blank.
I would like to display not only that it's past due, but how many days it's
past due.

Can anyone assist me with this formula?

Thanks.
 
G

Gord Dibben

=IF(F3<TODAY(),"overdue by " & TODAY()-F3 & " days","")


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Past due function 5
Calendar Logic: Recurring Dates 3
Counting Days 6
Count No of days past due 4
Sorting amounts in columns by due dates 7
Formula not being Friendly 3
If formula help 1

Top