# Calculate difference between two dates in days, months and year

1. ## Calculate difference between two dates in days, months and year

How to calculate difference between two dates in days, months and year. Please refer the attached document.  Register To Reply

2. ## Re: Calculate difference between two dates in days, months and year

Have a look at DATEDIF()
http://www.cpearson.com/excel/datedif.aspx  Register To Reply

3. ## Re: Calculate difference between two dates in days, months and year

Hi

Some others possible soloutions, i give you to my attacement

Regards.  Register To Reply

4. ## Re: Calculate difference between two dates in days, months and year

Is this possible to have a single formula for all the possibilities?  Register To Reply

5. ## Re: Calculate difference between two dates in days, months and year

Hi DeepakS.

Formula's in F4 & F5 are the sames.

If you modify the others two, you'll do this(I can not understand why to do this, but anyway..)

Regards  Register To Reply