# 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?

Formula:

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

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

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.

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

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

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.

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

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.

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

@InvisibleMan, Apologies but ..

... ours is not to reason why!!!

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1