Hello! Could you help me with a formula to add (sum) two periods. For example if I wish to add 01 year, 06 months, 12 days with 02 years, 07 months, 26 days how can I do it? With what formula? The correct answer would be 04 years 02 months and 08 days. But what formula in Excel would give me that answer. Thank you.
Hi, welcome to the forum
Dont see how you get 4 years?
How is the data entered or where does it come from?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi, welcome to the forum
Dont see how you get 4 years?
How is the data entered or where does it come from?
apoligies, I must not have been looking straight lol...
Year Month Day
apoligies, I must not have been looking straight lol...
Year Month Day
Enter in A3
Formula:
Please Login or Register to view this content.
Enter in B3
Formula:Please Login or Register to view this content.
Enter in C3
Formula:Please Login or Register to view this content.
v A B C 1 1 6 12 2 2 7 26 3 4 2 8.0
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you for your quick reply. But my problem is more complex. I use this formula to calculate the difference betwen two date:
=DATEDIF(A1;B1;"y")&" years, " & DATEDIF(A1;B1;"ym")&" months, " & DATEDIF(A1;B1;"md")&" days"
Then I want to add (sum) all the results. Maybe with a print screen with an example I can explain myself better.
Example Image.jpg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks