Doug from Boston needs to calculate an age in Excel.
Two easy formulas today: YEARFRAC and DATEDIF.
Two easy formulas today: YEARFRAC and DATEDIF.
Transcript of the video:
Learn Excel from MrExcel Podcast episode 2472. Calculate an age in Excel.
Hey, welcome back to the MrExcel netcast. I'm Bill Jelen.
Today's question from Doug in Boston: say that someone was born in 1955.
How can I calculate their age in Excel? Doug, that's a great question.
There's actually 2 easy ways to do that.
Let's put in today's date with =TODAY() and then to figure out the difference between those two. In years we could use the =YEARFRAC function.
Give it a start date and an end date. So that's 67.
Or the =DATEDIF function.
=DATEDIF, put in the earlier date, the later date and then in quotes you're looking for that in years like that.
Alright, so two different formulas.
It's great - Excel always has several ways to solve the problem, but this will make sure that you don't end up with the wrong date.
If you like these videos, please, down below, Like, Subscribe, and Ring the bell.
Feel free to post any questions or comments down in the comments below.
I want to thank Doug for sending that question in and I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
Let's hear you, Nancy.
Hey, welcome back to the MrExcel netcast. I'm Bill Jelen.
Today's question from Doug in Boston: say that someone was born in 1955.
How can I calculate their age in Excel? Doug, that's a great question.
There's actually 2 easy ways to do that.
Let's put in today's date with =TODAY() and then to figure out the difference between those two. In years we could use the =YEARFRAC function.
Give it a start date and an end date. So that's 67.
Or the =DATEDIF function.
=DATEDIF, put in the earlier date, the later date and then in quotes you're looking for that in years like that.
Alright, so two different formulas.
It's great - Excel always has several ways to solve the problem, but this will make sure that you don't end up with the wrong date.
If you like these videos, please, down below, Like, Subscribe, and Ring the bell.
Feel free to post any questions or comments down in the comments below.
I want to thank Doug for sending that question in and I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
Let's hear you, Nancy.
