Days Difference Between two days

[Guest]

I want to calculate No. of Days between two dates [Ex. 01-jan-2006 to
31-dec-2006], its should give 365 days, but in Excel Sheet it's giving 364
days,

Please help me.

 

[Guest]

364 is correct.

why?

because the difference between 1/1/2006 and 1/2/2006 is only 1

 

[Bill Ridgeway]

This is perennial trap. The answer lies in whether or not you are counting
gross or net days. In a situation of, say, the payment of a pension due on
01/01/2006 the number of days in payment is 365 (366). In a situation of,
the number of days available to do something, the number of days is 364
(365).

In the first example it is necessary to have =date2-date1+1.

Regards.

Bill Ridgeway
Computer Solutions

364 is correct.

why?

because the difference between 1/1/2006 and 1/2/2006 is only 1
--
Gary's Student
gsnu200703

I want to calculate No. of Days between two dates [Ex. 01-jan-2006 to
31-dec-2006], its should give 365 days, but in Excel Sheet it's giving
364
days,

Please help me.

 

[Guest]

good explanation
--
Gary's Student
gsnu200703

This is perennial trap. The answer lies in whether or not you are counting
gross or net days. In a situation of, say, the payment of a pension due on
01/01/2006 the number of days in payment is 365 (366). In a situation of,
the number of days available to do something, the number of days is 364
(365).

In the first example it is necessary to have =date2-date1+1.

Regards.

Bill Ridgeway
Computer Solutions

364 is correct.

why?

because the difference between 1/1/2006 and 1/2/2006 is only 1
--
Gary's Student
gsnu200703

I want to calculate No. of Days between two dates [Ex. 01-jan-2006 to
31-dec-2006], its should give 365 days, but in Excel Sheet it's giving
364
days,

Please help me.