Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Adding/subtracting dates to produce AGE in years, months, days

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Adding/subtracting dates to produce AGE in years, months, days

Resolved · Low Priority · Version 2010

Reply 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?

For upcoming training course dates see: Pricing & availability

Reply 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

Excel articles

· So what's new in Excel 2007?
· Don't Get Lost In A Sea Of Data, Use Excel Navigation
· Why Printing Needn't Be A Grey Area In Excel
· How To Use The Cell Styles Functionality In Excel 2010
· Combining Logical Functions In Excel

Please browse our web site to find out more about
2002 excel microsoft training and other Microsoft training courses.

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips