## How to calculate age from birth of date in Google sheet?

Have you ever tried to calculate age from the birth of date in Google sheet? This article, I will introduce some formulas for you to solve this job quickly and easily.

Calculate age based on birth of date with formulas in Google sheet

Calculate age based on birth of date with a handy feature in Microsoft Excel

#### Calculate age based on birth of date with formulas in Google sheet

The following formulas may help you to get the age from the birth of date. Please do as this:

1. Enter the below formula into a blank cell which will place the age result, and then drag the fill handle down to get the ages from the relative cells, all the ages have been calculated at once, see screenshot:

=IF(B2,DATEDIF(B2,TODAY(),"Y"),"")

Tips: If you want to get the exact years, months and days from the birth date, please apply the following formula, and you will get the following result as you need.

=datedif(B2, today(), "Y") & " years, " & datedif(B2, today(), "YM") & " months, " & datedif(B2, today(), "MD") & " days"

#### Calculate age based on birth of date with a handy feature in Microsoft Excel

To calculate the age from birthday in Microsoft Excel, Kutools for Excel's Date & Time Helper utility can do you a favor, with this feature, you can calculate the age based on the birth date from current day and a specific date.

Note:To apply the Date & Time helper features, firstly, you should download the Kutools for Excel, and then apply the features quickly and easily.

After installing Kutools for Excel, please do as this:

1. Click a cell where you want to output the result, and then click Kutools > Formula Helper > Date & Time helper, see screenshot:

2. In the Date & Time Helper dialog box, please do the following operations:

• Select Age option from the Type section;
• From the Date of Birth section, select the cell that contains the birth date that you want to calculate the age;
• Then, choose Today or Specified date that you want to calculate date based on;
• At last, specify the output result type as you need.

3. Then click Ok button, the first age has been calculated, and then select the cell and drag the fill handle down to get the ages from other date cells, see screenshot:

#### More relative articles:

• Calculate Age On A Specific Or Future Date
• For example, you have a person’s date of birth, if you need to calculate the age of this person based on a future or specific date, the following methods will help you achieve it .
• Calculate Age From ID Number In Excel
• Supposing, you have a list of ID numbers which contain 13 digit numbers, and the first 6 numbers is the birth date. For example, the ID number 9808020181286 means the birth date is 1998/08/02. How could you get the age from ID number as following screenshot shown quickly in Excel?
• Calculate The Difference Between Two Dates
• When dealing with the dates in a worksheet, you may need to calculate the difference between two given dates for getting the number of days, weeks, months or years. This article, I will talk about how to solve this task in Excel.
• Calculate Next Age Of A Person’s Birthday
• Normally, we can calculate a person’s age based on the birth date with a formula, but, have you ever considered calculating the age of his next birthday in Excel? Which means to calculate how old he is going to be in next birthday. This article, I will talk about some formulas for solving this task in Excel.

### Best Office Productivity Tools

 🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions… Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ... Super Lookup: Multiple Criteria VLookup  |   Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup .... Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List .... Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ... Featured Features: Grid Focus   |  Design View   |   Big Formula Bar   |  Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells   |  Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ... Top 15 Toolsets:  12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

#### Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

• Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
• Open and create multiple documents in new tabs of the same window, rather than in new windows.
• Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Thanks
this is what i was looking for
This comment was minimized by the moderator on the site
Tem um erro nas fórmulas, a sintaxe correta é com ponto e vírgula, as planilhas do Google não aceita somente a vírgula! Quando troquei a vírgula pelo ponto e vírgula, funcionou corretamente
This comment was minimized by the moderator on the site
Hello Juscelino,

Thanks for your comment. You are right. In Portugal and Spain, we should change the comma to the semicolon so the formula can work. The formulas in the article are more for universal usage. And we did not consider the special cases, like yours. Thanks for pointing that out. Have a great day.

Sincerely,
Mandy
This comment was minimized by the moderator on the site
Hej !

Tak for et godt site.

Hvordan bregner jeg om en person / dato har fødselsdag, og viser det i en celle med fx en QUERY syntax ?

Jeg har en række med datoer, og øsnker på et dashoard, at der kommer navne frem vis en dato rammer den aktuelle dato vi har :)

HOW TO DO :) ?
/Henrik
This comment was minimized by the moderator on the site
Its not working on google sheets now.
This comment was minimized by the moderator on the site
Hi, AOS,
Thank you!
This comment was minimized by the moderator on the site
Thank you this is exactly what I needed!!
This comment was minimized by the moderator on the site
exactly what I needed, thx
This comment was minimized by the moderator on the site
Awesome. Is it possible to set TODAY to a future date so you know their age on a specific date?
This comment was minimized by the moderator on the site
Or use this formula to get the age of the years, months and days:
=datedif(A2, B2, "Y") & " years, " & datedif(A2, B2, "YM") & " months, " & datedif(A2, B2, "MD") & " days"
This comment was minimized by the moderator on the site
Hello, Terry,
To calculate the age from a specific future date, you can apply the following formula:

=IF(A2,DATEDIF(A2,B2,"Y"),"")