Calculating inclusive dates
 

How many days including 1/1/2008 through 1/31/2008.

If you use the between dates calc cell#-cell# you will get 30 when there are
actually 31 days including the 1st day.

The problem is when a payment is made for a period calculating the number of
days, including the date of receipt. e.g 4/15/2007 thru 5/14/2007 or
2/1/2007 thru 3/15/2007

Calculating inclusive dates
 

So just add 1 to make it inclusive.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"spike" wrote in message
...
How many days including 1/1/2008 through 1/31/2008.

If you use the between dates calc cell#-cell# you will get 30 when there
are
actually 31 days including the 1st day.

The problem is when a payment is made for a period calculating the number
of
days, including the date of receipt. e.g 4/15/2007 thru 5/14/2007 or
2/1/2007 thru 3/15/2007

Calculating inclusive dates
 

=cellref-cellref +1 if you want to include the day of receipt.


Gord Dibben MS Excel MVP


On Sun, 2 Mar 2008 13:51:01 -0800, spike
wrote:

How many days including 1/1/2008 through 1/31/2008.

If you use the between dates calc cell#-cell# you will get 30 when there are
actually 31 days including the 1st day.

The problem is when a payment is made for a period calculating the number of
days, including the date of receipt. e.g 4/15/2007 thru 5/14/2007 or
2/1/2007 thru 3/15/2007