| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference between 2 dates, incl weekends, with variable work days | Excel Discussion (Misc queries) | |||
| Difference between 2 dates, incl weekends, with variable work days | Excel Worksheet Functions | |||
| Formula to find the working days difference between to dates? | Excel Discussion (Misc queries) | |||
| Please help!! Vacation Accrual Formula | Excel Worksheet Functions | |||
| difference between two dates in years, months and days. | Excel Worksheet Functions | |||
Linear Mode
