Does anyone here have an age calculating formula from date of birth & current date fields? Thanks
T Todd Smith Sep 14, 2004 #1 Does anyone here have an age calculating formula from date of birth & current date fields? Thanks
W Wercs Sep 14, 2004 #2 Assuming current date is in A1 and Birthdate is in B1.... =DATEDIF(B1,A1,"y") & " y " & DATEDIF(B1,A1,"ym") & " m" A great place for further info on this would be cpearson.com
Assuming current date is in A1 and Birthdate is in B1.... =DATEDIF(B1,A1,"y") & " y " & DATEDIF(B1,A1,"ym") & " m" A great place for further info on this would be cpearson.com
