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.
|