anniversary

[May Tan]

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

thanks

 

[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 *

 

[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

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/datedif.htm

 

[May Tan]

thanks for all the helps.

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

 

[Frank Kabel]

Hi
see the link I provided to you. You can also use DATEDIF for this