Calculate Age in Excel ☑️

Calculate Age in Excel ☑️

https://youtu.be/L7jA3E9wmJU



Calculate Age in Excel using the Datedif Formula. You can find age of a person in excel i 2 ways

1 - Age of person as of today

2 - Age of person on a specific date



To find the age in excel the best way is to write the date of birth in a cell and the current date in another cell then use the Datedif Formula to calculate the DOB in Excel



Datedif Formula calculates the difference between 2 date in 6 variations.

“”d”” Days between the two dates.

“”m”” Months between the two dates.

“”y”” Years between the two dates.

“”yd”” Days between the dates, as if the dates were in the same year.

“”ym”” Months between the dates, as if the dates were in the same year.

“”md”” Days between the two dates, as if the dates were in the same month and year.

Datedif Formula calculates the differnce between 2 date in 6 variations.

“”d”” Days between the two dates.

“”m”” Months between the two dates.

“”y”” Years between the two dates.

“”yd”” Days between the dates, as if the dates were in the same year.

“”ym”” Months between the dates, as if the dates were in the same year.

“”md”” Days between the two dates, as if the dates were in the same month and year.