Counting calendar days
Excel is, of course, correct, in that 30-28 =2, rather than 3.
If you want 3 instead of 2, the Excel method of adding one is to use +1.
Hence =B2-A2+1
--
David Biddulph
"musha-bsuha" wrote in message
...
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?
|