View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chapy354 chapy354 is offline
external usenet poster
 
Posts: 1
Default Counting dates including the beginning date.

I am trying to set up a formula to count days from start date to end date
including the start day. I have a total of 30 date sets that I need to track
and total. I have used =SUM(B3-A3)+1 and it accomplishes the task, but it
also adds 1 for every set regardless of the presence of dates in the cells. I
need it to only add what has been entered. Any help is greatly appreciated.