Excel formula to calculate age from date of birth
To calculate your age based on your Date Of Birth, using an Excel formula, you would need to use the Today function.
The Today function returns the current date based on your system clock on your PC or Laptop. This function has no arguments.
There is also the DateDif function which gives you the difference between two dates as shown below:
=DATEDIF(F1,Today(),"Y") - Y stands for years - Cell F1 contains the Date Of Birth
Each Date starting from the 01/01/1900 has a serial number assigned to it so in this case 1. So really the two dates you are using, Excel will just subtract the higher number from the lower number leaving the number of days between the two.
The formula would be:
Cell A1 would contain your date of Birth in Date(/)format e.g. 16/02/1973. The answer returned will generally be in Date format so it would need to be converted to Number Format which will represent the number of days between those two dates.
Finally divide the number of days by 365.25 to be more accurate which will return the number of years.
Related forum posts:
I have exported some data to excel, which has the candidate date fo birth, I know there is a formula within excel allowing it calculate the age for all those candidates....Does anyone know how to do it? Fingers crossed Thanks in advance.....a Swift response would be appreciated.
I would like to be able to calculate the age of a child on a daily basis. The formula you gave me on the course I attended was =TODAY( )-DOB)/365.4 I can't seem to make this work, could you please give me the correct formula. Thank you. I need this formula so I can know how many children I have under 2 or over 2 on a daily basis.
I want to create a query when I only get details of people who are older than a certain date. I have set up date of birth in tables with an input mask of short date, but when I query it with <00/00/00 I get a modified query <the day rather than the year. How can I alter this?
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
If date of birth is given, and a further date, how can the age of the person at the further date be calculated?
How does one calculate a list of peoples' ages on a particular date easily?
Other posts you might be interested in:
I can make a calculation of days ( In this case 'ageatdeath' by using a macro to subtract 'dateofdeath' from 'dateofbirth' - how do I make this show in days, weeks, months, years etc rather than simply in days?
How do you calculate age from DOB?
We have got details of people's dates of birth but would like Access to tell us their ages automatically.
Hi Matthew 2 ways : 1. REMOVE THE MENU Right-click on the Toolbars menu, choose CUSTOMISE. Left click on the menu you want to remove from the toolbar, and drag it to the Customise Dialog box. You will notice a RED X next to the cursor. When you release the mouse button, the menu will be removed. 2.RESET THE TOOLBAR Right-click on the Toolbars menu, choose CUSTOMISE. Select the TOOLBARS Tab Select the Toolbar that the SCENARIOS MENU appears on Click RESET. If the SCENARIOS MENU
Hi Cecelia Thanks for attending our [url=/microsoft-excel-training.php]microsoft excel training[/url] vba course. You can use the Drawing toolbar to align objects. First make sure the drawing toolbar is turned on Tools > Customize then choose the Toolbars tab. Make sure there's a tick beside the Drawing toolbar Then select the objects you would like to align. You may find it easy to hold down the control key then click on each object until they are all selected From the Dr
Shady deeds are afoot at Dodd Gee Enterprises. An email is being sent out to their entire customer base with a free horoscope reading that is intended to persuade the customer to buy a targeted product. In order to do this, the dates of birth of the entire customer list need to be separated into months. This article explains how this is done.
Would you like to know how many days you've been alive? This simple formula in Excel allows you to find out. By using the same simple rules, you could take the process further and find out how many hours, or even minutes you have been here.
Have you ever wondered how a date is actually stored in Excel? This article describes how Excel stores dates and covers an example of how this can be used in calculations.
London & UK
Welcome. Please choose your application (eg. Excel) and then post your question.
Our Microsoft Qualified trainers will then respond within 24 hours (working days).
Any suggestions, questions or comments? Please post in the Improve the forum thread.