formula help: calculate length of employment

[Guest]

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

 

[SteveG]

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

 

[Guest]

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())