Excel formula to calculate age from date of birth

Forum home » Topics » Excel formula to calculate age from date of birth

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:

Getting Age from Date of Birth Formula

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.

Read forum post


Calculated age of person each day

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.

Read forum post


Criteria Query

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?

Read forum post


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

Read forum post


Calculating ages from dates

If date of birth is given, and a further date, how can the age of the person at the further date be calculated?

Read forum post


How to calculate age on a particular date

How does one calculate a list of peoples' ages on a particular date easily?

Read forum post


Other posts you might be interested in:

Access 2003

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?

Read forum post


Calculating Age

How do you calculate age from DOB?

Read forum post


Dates of Birth

We have got details of people's dates of birth but would like Access to tell us their ages automatically.

Read forum post


RE: how do I remove the scenarios menu from the toolbar?

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

Read forum post


RE: Align CheckBoxes

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

Read forum post


Related articles

Using Dates Within Excel

Read article


Sorting Birthdates Into Their Respective Months In Excel

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.

Read article


Find Out Your Age In Days With Excel

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.

Read article


How Are Dates Stored In Excel?

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.

Read article



Training courses


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.

Server loaded in 0.11 secs.