# calculate total number of days between two days based on 365 days year

1. ## calculate total number of days between two days based on 365 days year

i need to calculate total number of days between two days in excel based on 365 days year.
eg: start date: 01/02/1991
end date: 31/01/2016
Result: 9125 ( 25years*365 days)
Any formula?  Register To Reply

2. ## Re: calculate total number of days between two days based on 365 days year

Formula:  `Please Login or Register  to view this content.`  Register To Reply

3. ## Re: calculate total number of days between two days based on 365 days year

Try

=(YEAR(B1)-YEAR(A1))*365

A1 = start year

B1=End Year  Register To Reply

4. ## Re: calculate total number of days between two days based on 365 days year

sir,
this is not iam looking for. ineed actual number of days between two dates irrespective of years*365
ie: end date-startdate=total number of days based on a 365 days year.
01/02/1991 to 17/05/2001= ?  Register To Reply

5. ## Re: calculate total number of days between two days based on 365 days year

Post SEVERAL examples and tell us what results you expect.  Register To Reply

6. ## Re: calculate total number of days between two days based on 365 days year

Try

=SUMPRODUCT((TEXT(ROW(INDIRECT(A1&":"&B1)),"ddmmm")<>"29Feb")+0)

Found on this forum

http://www.excelforum.com/excel-gene...eap-years.html  Register To Reply

7. ## Re: calculate total number of days between two days based on 365 days year

To be fair, you did say
25years*365 days
and that is exactly what you have been given.

In reality, you could just do
Formula:  `Please Login or Register  to view this content.`
but that gets you 9130 because of all the Leap Years.

So, the real question is, why do you want to get the number of days between two dates on the basis of a 365 day year when that will be an inaccurate calculation.  Register To Reply

8. ## Re: calculate total number of days between two days based on 365 days year

@John: nice solution, credit to DLL ... though still don't understand the relevance of the calculation.  Register To Reply

9. ## Re: calculate total number of days between two days based on 365 days year

Do "Evaluate Formula" and you will set how it works: each date (list generated by ROW(INDIRECT...) is checked to see if it is 29th Feb. You get a list of TRUE/FALSE which is converted to 1/0 by the "+0". SUM of these gives the result.

Very clever !!!  Register To Reply

10. ## Re: calculate total number of days between two days based on 365 days year

Sorry John, you misunderstand me. I know how the formula works, just not why anyone would want the output from it. If you have two dates and want to know the number of days between them, I don't understand why you would ignore the Leap Days.  Register To Reply

11. ## Re: calculate total number of days between two days based on 365 days year

@InvisibleMan, Apologies but ..

... ours is not to reason why!!!  Register To Reply

12. ## Re: calculate total number of days between two days based on 365 days year

sir great this works and gives what i want thanks  Register To Reply