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

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

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

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

Hi

Some others possible soloutions, i give you to my attacement

Regards.

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

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

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

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