L
Leyland
I am using this formula to get the age of someone in years and days. It
works well execpt I cannot find a way of adjusting for leap years. Any ideas
=DATEDIF(A1,B1,"Y")&"YEARS"&DATEDIF(A1,B1."YD")&"DAYS"
works well execpt I cannot find a way of adjusting for leap years. Any ideas
=DATEDIF(A1,B1,"Y")&"YEARS"&DATEDIF(A1,B1."YD")&"DAYS"