G Guest Oct 12, 2004 #1 I'm looking for a formula to be able to calculate a list of employee's ages based on today's date. Thanks! M Burton
I'm looking for a formula to be able to calculate a list of employee's ages based on today's date. Thanks! M Burton
J JulieD Oct 12, 2004 #2 Hi from Chip Pearson's website (www.cpearson.com) Here's a very exact formula off of Chip Pearson's website: =DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW Click to expand...
Hi from Chip Pearson's website (www.cpearson.com) Here's a very exact formula off of Chip Pearson's website: =DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW Click to expand...
B Bernard Liengme Oct 12, 2004 #3 Use the undocumented function DATEDIFF I think Clip at www.cpearson.com has details best wishes
J JulieD Oct 12, 2004 #4 Hi i'll try that again =DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " & DATEDIF(A1,NOW(),"md") & " days" with the person's birthdate in A1. Cheers JulieD
Hi i'll try that again =DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " & DATEDIF(A1,NOW(),"md") & " days" with the person's birthdate in A1. Cheers JulieD
