View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pandd15 pandd15 is offline
external usenet poster
 
Posts: 7
Default Calculating the days between two dates

I have dates in several columns that track how long various processes take.
These dates are manually added however the process may still be incomplete
thus leaving a blank in that column. These blank columns are causing my
calculations to have incorrect #'s. Is there a way I can leave a cell blank
without having this happen?

In this example this process took 39 days for line 1 but line 2 wasn't
complete so no date has been inserted because redlines aren't complete this
causes a long incorrect date. Thanks so much again.

A B C

In for Redlines Back from Redining

1- 2-Feb-09 26-Mar-09 39
2- 4-Nov-08 2837