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?

Formula:

Please Login or Register  to view this content.

Try

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

A1 = start year

B1=End 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= ?

Try

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

Found on this forum


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

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.

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

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

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.

sir great this works and gives what i want thanks