anniversary

M

May Tan

is there a function in excel that can auto calculate the nos. of years the
staffs serving?

thanks
 
A

A.W.J. Ales

May Tan,

With the startdate in A1 and the "Calculationdate" in A2 try
=DATEDIF(A1,A2,"y")

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
H

Hardy

If start date is in A1, then put the following into A2 and will sho
number of completed years.

=IF(TODAY()-DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))<0,(YEAR(TODAY())-YEAR(A1))-1,YEAR(TODAY())-YEAR(A1))&
Yrs"

Hope this helps
 
M

May Tan

thanks for all the helps.

Is there a function that show not only the years, but with months as well?
 
Top