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
