Forum home » Delegate support and help forum » Microsoft Excel Training and help » Getting Age from Date of Birth Formula

Getting Age from Date of Birth Formula

ResolvedVersion Standard

Wed 19 Mar 2008, 11:21 Delegate James said...

James has attended:
Excel Intermediate course

Getting Age from Date of Birth Formula

Sorry I know I asked this question before but I can not find forum post

I know you can get the age from data as there is a forumla to use....can anyone let me know what it is

Thanks

Tue 25 Mar 2008, 11:44 Delegate Paul said...

RE: Getting Age from Date of Birth Formula

I'm sure you can go about it in a long winded way, but I am not aware of a specific formula to do this. Perhaps I'm wrong.

Anyway, I would do something like =today()-A1 in a cell (let's say, cell B1 for demonstrative purposes) Make sure that this cell is formatted as a number, with no decimal places, then in cell C1, you can do something like this =ROUND(B1/365,0)

This will give you the age of the person/thing in years.

For instance, cell A1 contains 04/10/1984

in cell B1, type =today()-A1. This will return 8573 (the amount of days since 4th October 1984

in cell C1 type =ROUND(B1/365,0) this will give the result of 23.

Wed 26 Mar 2008, 17:26 Trainer Rich said...

RE: Getting Age from Date of Birth Formula

Hi James,

Your original forum post is here:
https://www.stl-training.co.uk/post-10350-getting-age-date-birth.html #10350

To see all your posts, choose 'Your posts/answers' from the top right of any forum page (when you are logged in).

Regards, Rich

Training courses

98.6 % recommend us

More live stats...

Training information:

Excel tip:

LARGE and SMALL functions and their uses

Two of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest?

The =LARGE(array,n) returns the nth largest value of a series.

The =SMALL(array,n) function returns the nth smallest value of a series.

In both functions, 'n' represents the order of the number you want to display. For example, putting in 2 as n will give you the second highest number; putting in 3 as n will give you the third highest number.

View all Excel hints and tips

Getting Age from Date of Birth Formula

Getting Age from Date of Birth Formula

RE: Getting Age from Date of Birth Formula

RE: Getting Age from Date of Birth Formula

Excel articles

Excel tip:

LARGE and SMALL functions and their uses