View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mrs H Mrs H is offline
external usenet poster
 
Posts: 1
Default Count No of days past due

I need a formula to count the number of days from a date in a cell to the
current date if another cell is null.

Example:

Date Sent Date Received Days Past Due
1/29/09 Null or blank

Also I have this formula:
=TODAY()-K15 but if the cell it refers to is null, it returns a number
39849 instead of zero - why is this?