Days Difference Between two days
 

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.

Days Difference Between two days
 

364 is correct.

why?

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


"Ibrahim" wrote:

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.

Days Difference Between two days
 

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

"Gary''s Student" wrote in message
...
364 is correct.

why?

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


"Ibrahim" wrote:

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.

Days Difference Between two days
 

good explanation
--
Gary's Student
gsnu200703


"Bill Ridgeway" wrote:

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

"Gary''s Student" wrote in message
...
364 is correct.

why?

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


"Ibrahim" wrote:

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.