View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rrupp rrupp is offline
external usenet poster
 
Posts: 22
Default Number of days past due

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.