getting age date birth

AI Training: For Busy Decision Makers & Professionals Book now

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

resolvedResolved · Low Priority · Version Standard

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

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.

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

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips


Server loaded in 0.11 secs.