View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
srctr srctr is offline
external usenet poster
 
Posts: 24
Default Vacation days from date of hire

I need to set up a worksheet that will allow me to calculate vacation days
from Hire date as follows: Employee works for 90 days (intro period), then
will accrue 1 vacation day at the beginning of the first of the following
month and one additional vacation day for each month after for a maximum of
10 days per year. Thereafter they receive 10 days on January 1st after their
first 12 months of service. 4th thru 9th they will recieve 15 days on
January 1st.
--
cao