Thread
:
DATEDIF and leap years
View Single Post
#
1
Leyland
Posts: n/a
DATEDIF and leap years
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")&"D AYS"
Reply With Quote