Thread: Counting calendar days
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
musha-bsuha[_2_] musha-bsuha[_2_] is offline
external usenet poster
  
Posts: 1
Default Counting calendar days
When I count calendar days, using =VALUE(B2-A2) or even just =(B2-A2), it
always omits one day. For instance 28/09/2009 to 30/09/2009 the formula
counts it as 2 days, while actually it's 3 days (28-29-30). How can I correct
this?
Reply With QuoteReply With Quote