Calculate number of years and months employed using hire date and.

1. Calculate number of years and months employed using hire date and.

In Excel 2003, I want to calculate the number of years and months employed
using a hire date and the current date. i.e.
06/28/2006 – 06/25/2005 = 11 months
06/28/2006 – 06/25/2004 = 1 year 11 months
06/28/2006 – 08/01/2000 = 5 years 10 months
06/28/2006 – 04/01/2000 = 6 years 2 months

Somebody must have done this before, yes?

2. Re: Calculate number of years and months employed using hire date and.

=DATEDIF(start_date,end_date,"y")

=DATEDIF(start_date,end_date,"ym")

=DATEDIF(start_date,end_date,"m")

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

"TryingTime" <TryingTime@discussions.microsoft.com> wrote in message
news:732070F3-38CC-4883-9866-46FEA8DEACB2@microsoft.com...
> In Excel 2003, I want to calculate the number of years and months employed
> using a hire date and the current date. i.e.
> 06/28/2006 - 06/25/2005 = 11 months
> 06/28/2006 - 06/25/2004 = 1 year 11 months
> 06/28/2006 - 08/01/2000 = 5 years 10 months
> 06/28/2006 - 04/01/2000 = 6 years 2 months
>
> Somebody must have done this before, yes?
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1