98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Adding/subtracting dates to produce AGE in years, months, days
Adding/subtracting dates to produce AGE in years, months, days
Resolved · Low Priority · Version 2010
Fri 10 Sep 2010, 12:08Delegate Claire said...
Claire has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Adding/subtracting dates to produce AGE in years, months, days
Example:
I have two cells containing dates A1 = 04/07/1965, B1= 01/09/2010, in cell C1 I have the formula =B1-A1 and it reports 16495 ie the number of days from A1 to B1. I wish the cell to report the answer as number of years, months and days i.e. 45y 2m, 9d. In other words the age of the subject.
How do I format the cell to do this?
Mon 13 Sep 2010, 10:41Trainer Anthony said...
RE: Adding/subtracting dates to produce AGE in years, months, da
Hi Claire, thanks for your query. It is difficult, but not impossible, to do this. It would take rather a long post on this forum to take you through it step by step but here is a link which covers what you need to know:
http://www.meadinkent.co.uk/xl_birthday.htm
Hope this helps,
Anthony
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Moving between split pane sections in a spreadsheetIf you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections: |
