calculating seniority dates to determine vacation time earned

Yes I mean years.

Attached is a short file.

The hire date is 8/31/2013. Today is 1/14/2015. Their seniority is 1 year 4 months and 14 days.

For a partial year, anyone hired after January 1 2015 will get a portion of 2 weeks. I.E. hire date 4/1/15 would be 9/12 therefore vacation is 9/12 of 10 days = 7.5 days.

Sorry, I type too fast 10 years equals 4 weeks.

I think this answers all questions.

Cyndi