Quick methods to get age from birthdate in Microsoft Excel

If you need to calculate any person’s age from his date of birth to current date then you can use different methods to get age from birthdate in Excel. There are lot of team members or employees working in the office and you can easily convert birthdate to age quickly using Excel.

If you want to use manual calculation method to compute the age of any person one by one then you have to consume lot of time. But, if you don’t have enough time and also calculate the age from birthdate then you have to take help different function in Excel. All we know Excel, is widely used application software around the world, which provide the quick result of complex calculations and many more. You can also apply a trick to calculate your age without using function in Excel.

Must Read: How to remove spaces from text string in Excel

Quick methods to Get age from birthdate in Excel

Most of the person have to useĀ one or two methods to calculate the age from birthdate in Excel. But, if this article we have to discuss several quick methods which helps you to get age from birthdate in Excel. If you want to calculate the age of any person’s then you have to take few given simple steps in this article.

Quick methods to Get age from birthdate in Excel

Method 1: Using INT function

Step 1: Open an existing worksheet or create a new worksheet in Excel.

Step 2: Type your date of birth in MM/DD/YYYY format in cell A2 and current date in cell B2.

Step 3: Type the following given formula in cell C2 to get age from birthdate in Excel =INT((B2-A2)/365). Now, press enter you will get the year of any person’s age from his date of birth to current date.

Method 2: Using INT with YEARFRAC function

Step 1: Open an existing worksheet or create a new worksheet in Excel.

Step 2: Type your date of birth in MM/DD/YYYY format in cell A2 and current date in cell B2.

Step 3: Type the following given formula in cell C2 to get age from birthdate in Excel =INT(YEARFRAC(A2,B2)). You can also type another formula =INT(YEARFRAC(A2,TODAY())) to calculate the age in Excel. Now, press enter you will get the year of any person’s age from his date of birth to current date.

Method 3: Using ROUNDDOWN with YEARFRAC function

Step 1: Open an existing worksheet or create a new worksheet in Excel.

Step 2: Type your date of birth in MM/DD/YYYY format in cell A2 and current date in cell B2.

Step 3: Type the following given formula in cell C2 to get age from birthdate in Excel =ROUNDDOWN(YEARFRAC(A2, TODAY(), 1), 0). You can also type another formula =ROUNDDOWN(YEARFRAC(A2, B2, 1), 0) to calculate the age in Excel. Now, press enter you will get the year of any person’s age from his date of birth to current date.

Method 4: Using DATEDIF with NOW function

Step 1: Open an existing worksheet or create a new worksheet in Excel.

Must Read: 3 Ways to quickly find duplicate values in Excel

Step 2: Type your date of birth in MM/DD/YYYY format in cell A2 and current date in cell B2.

Step 3: Type the following given formula in cell C2 to get age from birthdate in Excel =DATEDIF(A2,NOW(),”Y”). Now, press enter you will get the year of any person’s age from his date of birth to current date.

Method 5: Using DATEDIF with TODAY function

Step 1: Open an existing worksheet or create a new worksheet in Excel.

Step 2: Type your date of birth in MM/DD/YYYY format in cell A2 and current date in cell B2.

Step 3: Type the following given formula in cell C2 to get age from birthdate in Excel =DATEDIF(A2,TODAY(), “Y”). Now, press enter you will get the year of any person’s age from his date of birth to current date.

Method 6: Using DATEDIF with DATE function

Step 1: Open an existing worksheet or create a new worksheet in Excel.

Step 2: Type your date of birth in MM/DD/YYYY format in cell A2 and current date in cell B2.

Step 3: Type the following given formula in cell C2 to get age from birthdate in Excel = DATEDIF(DATE(1977,2,8),DATE(2016,8,24),”Y”). Now, press enter you will get the year of any person’s age from his date of birth to current date.

Must Read: How to copy and paste only non-blank cells in MS Excel

I hope after reading this article you can easily understand quick methods to get age from birthdate in Excel. You have to quickly convert any person’s date of birth in to the age using the given functions in Excel. If you have any query regarding this guide then please write us in the comment box. Thanks to all.

Leave a Reply

Your email address will not be published. Required fields are marked *