Thread: Finding days between cells C and L where the cells may be empty
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jack
 
Posts: n/a
Default Finding days between cells C and L where the cells may be empty
Cells C8 and L8 represent entry and exit dates. I used the formula
=(L8-G8)/7 to find the number of weeks between the dates. This works when
there are dates in cells C8 ands L8. However, when the cells do not contain
dates, I get the VALVE error reading in the cell designated to show rthe
number of weeks. How can I modify the formula to address instances when the
cells will be left empty?

Thanks
Reply With QuoteReply With Quote