# Calculate Year Month and Days and Add them

1. ## Calculate Year Month and Days and Add them

Friends!
I like to calculate the number of years months and dates from xxx date to yyyy days
For example:

25/6/1976 to 15/9/1986 - Calcualte the number of years,months and days

Please check the attached sample work book for my requirements

I solved this with your help friends..

2. ## Re: Calculate Year Month and Days

Have a look at this: http://www.cpearson.com/excel/datedif.aspx

Dom

3. ## Re: Calculate Year Month and Days

Use the Datedif function

4. ## Re: Calculate Year Month and Days

I solved the above calculation using domski's help. Thanks a lot
Finally I need one more calculation.

Using that calculation I got the following result. I want to add them.
Example:
1) 1 years 1 months 4 days
2)9 years 10 months 26 days
3)6 years 10 months 5 days

The result should be = 17 years 9 months 5 days

5. ## Re: Calculate Year Month and Days

That's covered on Chip Pearson's page

6. ## Re: Calculate Year Month and Days

I oculdn't find anything releated to the totaling the result in that page. If you find anything please post here. thanks

I got 3 results
1) 1 years 1 months 4 days
2)9 years 10 months 26 days
3)6 years 10 months 5 days

I want to sum the three results

7. ## Re: Calculate Year Month and Days and Add them

Any help will be appreciated friends!

8. ## Re: Calculate Year Month and Days and Add them

I think your sums are out slightly, I get 17 years, 10 months and 4 days.

Anyway this should do the trick without having to do the individual datedif calculations:

=DATEDIF(DATE(1900,1,1),SUM(C3:C18-B3:B18),"y")&" years "&DATEDIF(DATE(1900,1,1),SUM(C3:C18-B3:B18),"ym")&" months "&DATEDIF(DATE(1900,1,1),SUM(C3:C18-B3:B18),"md")
&" days"

Confirmed with Ctrl+Shift+Enter as it's an array formula.

Dom

9. ## Re: Calculate Year Month and Days and Add them

You are right Mr. Dom.17 years, 10 months and 4 days. Thanks a lot for the array solution also.

Solved.

Thanks again.

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