tenure
You could use the undocumented DATEDIF Function.
Assuming startdate in A1
=DATEDIF(A1,TODAY(),"y") & " Years "
Startdate in A6 and enddate in A7 and you want years, months, days.
=DATEDIF(A6,A7,"y") & "years," & DATEDIF(A6,A7,"ym") & "months,"&
DATEDIF(A6,A7,"md") & "days,"
Gord Dibben MS Excel MVP
On Mon, 24 Dec 2007 10:32:01 -0800, Janice Reid wrote:
I need to Create a formula that calculates the employees tenure in years. In
cell G7
But I'm having trouble I don't understand how to do this.
|