98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Resolved · 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 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:Cycling through Absoulte cell referencesIf 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. |