View Single Post
  #3   Report Post  
tjtjjtjt
 
Posts: n/a
Default

Is there a reason why COUNT won't work?

tj

"skchth" wrote:

I am trying to count the days between 2 dates. Start date 01/01/01 and End
date 01/05/01 should return 5. However the Datediff function will return 4
because it doesn't count the start date. Adding "+1" to the Datediff function
does not work for me because when the cells with the start and end date are
empty the cell with the Datediff function must be empty.