How to Calculate Age in Excel, Simple and Fast – Student Zone – Hello, Friend Zona. Calculating a person’s age data can actually be done through Microsoft Excel, you know. The formula is fairly simple and very easy to apply.

Well, now Mimin will share how to calculate age in Excel that is easy and fast. No need to use a calculator anymore. Come on, see the following review.

Also Read: How To Quickly Delete Double Data in Excel, Really Easy!


  • Open the Excel data containing the age, then use the formula =(TODAY()-B2)/365. This formula aims to divide between the current date and the date of birth. Then divide by 365 which represents the number of days in a year to get the year of birth.
Excel Drawing (Photo: Ablebits)
  • Next, to display the full year use INT to be able to round the decimal to the nearest whole number. So the formula becomes =INT((TODAY()-B2)/365). Then, stay in Enter okay.
Excel Drawing (Photo: Ablebits)

How to Calculate Age in Excel, Simple and Fast

That’s Mimin’s review of how to calculate age quickly and easily in Excel. Come on.

Hopefully this review is useful for Friend Zone. Don’t forget to keep abreast of information about students and the world of lectures and turn on notifications. See you later.

Also Read: Easy Ways to Lock Table Titles in Microsoft Excel

Create by ipadguides in category of > Student Room