View Single Post
  #1   Report Post  
Leyland
 
Posts: n/a
Default 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"