How To Calculate

Learn how to calculate anything
Menu
  • bmi
Home
statistics
How to Calculate Age in Excel.
statistics

How to Calculate Age in Excel.

Rosemary Njeri

In this case. we are going to learn how to calculate age using Microsoft excel.

Microsoft excel makes it easier to work out anything even when a large set of data is involved.

Formula to calculate age in excel.

Well after you have your data in the excel spreadsheet;

Calculate Age in Excel.

You will add another column for age.

To work out the age, you will have to use the following formula.

Calculate Age in Excel.
Calculate Age in Excel.

We divide the today’s function by 365.25 to get the age in years format.

After clicking enter, all you need to do is drag the bottom right corner up to the end of your data set and you would have calculated age in excel.

Calculate Age in Excel.

We can round down to get whole number by using the round down function.

=ROUNDDOWN(D2,D6)

Calculate Age in Excel.
Share
Tweet
Reddit
Pinterest
Email
Prev Article
Next Article

Related Articles

How to Calculate Sample Mean.
We can either define sample mean as an estimate of …

How to Calculate Sample Mean.

How to Calculate Coefficient of Variation.
The coefficient of variation (CV) is the ratio of the …

How to Calculate Coefficient of Variation.

Leave a Reply Cancel Reply

Popular Posts

  • 5 Best AI Apps for Solving Complex …
    March 22, 2023 0

Categories

learntocalculate.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.com.

How To Calculate

Learn how to calculate anything

Pages

  • About Us
  • Contact Us
  • Privacy Policy
Copyright © 2023 How To Calculate

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh