formula help: calculate length of employment
 

I am trying to find a formula that will calculate length of employment based
off of hire date and todays date? any suggestions?

formula help: calculate length of employment
 

The DATEDIF function will work. Chip Pearson's site should have the
answer your looking for.


http://www.cpearson.com/excel/datedif.htm


Regards,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=527636

formula help: calculate length of employment
 

Do you want years of employment? months? days? Here is a formula for days,
manipulate it to produce months or years, or whatever you would like.

=DAYS360(hire_date,TODAY())

--
Regards,
Dave


"Mharper" wrote:

I am trying to find a formula that will calculate length of employment based
off of hire date and todays date? any suggestions?