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:
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.
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.
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:
Click Download and free trial Kutools for Excel Now !
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
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!
