Excel Calculate Age using Date Function Today

Excel Calculate Age using Date Function Today video will help you learn how to use Today Date Function in Excel. In this demo, you will learn how to calculate the age of a person using today funtion. You will also learn basic operation order in excel in this video.

This applies to:
Excel 2007 and above

#excelLearningSeries #excel #excel2016 #excelDateFunction #datefunction #calculation

[abdullkadirabdullahi]

you have really answered the name syed. you are worth this name, than for everything. i have been following you for more than 2 weeks now. remain blessed

[trivanannakkarage]

Perfect explanation was so helpful! Thank you very much!! Blessing to you!

[khanyisiletachiona]

Thanks Syed U have no idea how helpful this was

[ryanm.]

This is very helpful thank you so much👍🏼👍🏼👍🏼😊

[omarsulieman]

Thank you very much this is very helpful

[frankaduagyapong]

Thanks for the explanation, quite straight to the point. Also wish to you help on this, if I want to know an age of hire, with birthdate and hire date available, how different could you assist, please? Say for instance, hire date : 1/6/1995 and birthdate :3/19/1959, will today, as in current date, which way different time line be considered in use?

[saleemshaik]

thanks brother it helps me for setting data

[monishkumar]

How to calculate age from today excluding weekends ? Could you please help

[paginadefandepes]

Good vedio sir . Using edate is better I think ..

[bhieratvlog]

Hi Sir good evening ☺️ thanks for information, my I know how to compute absent rate ?

[Mukadam...]

Syed .
Please can u tell me how can i get age as of today everytime i open excel from date which is already in excel

[titilore]

Hello! I need help! There isn’t any videos explaining how to calculate Gestational Age? I need to calculate the gestational age in weeks and days on today’s date. How can I do this?

[dibyenduhazra]

I see some issues when the date is before the year 1900

[susansenwamadi]

Good evening on my side it shows #value!

[athaar.a]

If I want the current age, should the whole column on "start date" contain today's date?

[exas]

Thanks for the lesson.

How to calculate age in years and months ?

[miam]

Syed, follow on question. For my purpose I need to take today’s date and subtract a date and get months. I need the number of months from today a person has been in their position. I tried =(today()-G2)/12. That did not give the correct number of months.

[kimholloway]

Hello Syed, I use the formula exactly as shown for the date 9-Jul-07 but the answer that populates is shown in 12-Jan-00 format. I've made sure the date formats are the same in both columns I'm working with. Can you help?

[macdolfaquino]

I want to compute based on current date and the age should be in months and ignore formula or no display in age if birthday is blank

[mikesample]

how do you set up the calculation to say "N/A" if the date cell is left blank?