Calculate Age in Years, Months and Days
Jan 20, 2022
=YEARFRAC(B3, TODAY())=DATEDIF(B3, TODAY(), "y")
& " years "
& DATEDIF(B3, TODAY(), "ym")
& " months "
& DATEDIF(B3, TODAY(), "md")
& " days"=LAMBDA(dob, DATEDIF(dob, TODAY(), "y") & " years " & DATEDIF(dob, TODAY(), "ym") & " months " & DATEDIF(dob, TODAY(), "md") & " days")
=DATEDIF(B3, C3, "y")
& " years "
& DATEDIF(B3, C3, "ym")
& " months "
& DATEDIF(B3, C3, "md")
& " days"=LAMBDA(start_date,end_date, DATEDIF(start_date, end_date, "y") & " years " & DATEDIF(start_date, end_date, "ym") & " months " & DATEDIF(start_date, end_date, "md") & " days")
GitHub:
https://github.com/havishmad/excel_calculate_age_ymd
YouTube:
https://youtu.be/gPu5yG1ymhs
