I am trying to find a formula that will calculate length of employment based
off of hire date and todays date? any suggestions?
The DATEDIF function will work. Chip Pearson's site should have the
answer your looking for.www.cpearson.com/excel/datedif.htmRegards,
Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=527636Do 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,
Davequot;Mharperquot; wrote:
gt; I am trying to find a formula that will calculate length of employment based
gt; off of hire date and todays date? any suggestions?
off of hire date and todays date? any suggestions?
The DATEDIF function will work. Chip Pearson's site should have the
answer your looking for.www.cpearson.com/excel/datedif.htmRegards,
Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=527636Do 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,
Davequot;Mharperquot; wrote:
gt; I am trying to find a formula that will calculate length of employment based
gt; off of hire date and todays date? any suggestions?
文章標籤
全站熱搜
