Calculate Age in Excel – You might be doing it wrong

In this short video, I'll tell you how to calculate ​someone's age based on a date of birth and how you may be doing it wrong right now.

​Once you realize that ​age is just the difference in years between a date of birth and the current date, it becomes easy to do. Check the video for the complete explanation.

V​ideo

​Formula

The formula to calculate age ends up being:

​=DATEDIF(Date of birth, TODAY(), "y")

​Pretty simple, huh?

​How many days old are you?

You can use other arguments instead of "y" to also calculate how many months and days someone is old. For example:

=DATEDIF(4/29/2020, TODAY(), "ym")

will return the number of months since this person's last birthday. So if your birthday is ​​January 1st and it is currently ​February 1st, this will return 1.

You can combine this to calculate age in years + months. For example, if the date of birth is in cell A1:

="You are " & DATEDIF(A​1, ​TODAY(), "y") & " years and " & DATEDIF(A1, ​TODAY(), "ym") & " months old."

This will return something like: You are 28 years and 3 months old.

You can even add the number of days in there, using "md" as third argument! We'll leave that up to you 😉

We hope you learned something today. It's really quite easy to calculate always up-to-date ages in Excel. ​​If there are any other subjects you'd like us to cover, let us know in the comments.


You may also like

Is there a ‘minus sum’ for spreadsheets?

7 Excel Tricks for Marketers

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"36c04":{"name":"Main Accent","parent":-1},"3a8fd":{"name":"Accent Light","parent":"36c04","lock":{"saturation":1,"lightness":1}}},"gradients":[]},"palettes":[{"name":"Default","value":{"colors":{"36c04":{"val":"rgb(255, 204, 102)","hsl":{"h":40,"s":1,"l":0.7}},"3a8fd":{"val":"rgb(241, 241, 241)","hsl_parent_dependency":{"h":0,"s":0,"l":0.94}}},"gradients":[]},"original":{"colors":{"36c04":{"val":"rgb(255, 204, 102)","hsl":{"h":40,"s":1,"l":0.7}},"3a8fd":{"val":"rgb(241, 241, 241)","hsl_parent_dependency":{"h":0,"s":0,"l":0.94}}},"gradients":[]}}]}__CONFIG_colors_palette__

​Get Good at Excel on Autopilot

Sign up to our newsletter and receive ​Excel articles, tips and tricks delivered straight to your inbox. All you have to do is read them! ​Plus, to get you started, you'll receive a PDF with 200+ Excel shortcuts.

__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"2dd0d":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"2dd0d":{"val":"rgb(45, 164, 92)","hsl":{"h":143,"s":0.57,"l":0.41}}},"gradients":[]},"original":{"colors":{"2dd0d":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45}}},"gradients":[]}}]}__CONFIG_colors_palette__
Join List
>