Counting calendar days

M

musha-bsuha

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?
 
M

Mike H

Hi,

I'm not sure I agree with your reasoning but if that's what you want then
you'll have to do the subtraction and add 1 back

=B2-A2+1

Mike
 
P

Pete_UK

Use this:

=B2-A2+1

if you want to treat both dates as inclusive.

Hope this helps.

Pete
 
D

David Biddulph

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top