I am working on a project where I have to calculate vacation time from 1/07
(this will change to each new year) to the last day of the previous month.
The calc needs to look at the hire date and if the employee was hired after
the 15th of the month, then the vacation time calc would not occur until the
end of the next month. This has to update each time it is opened based on the
parameters above until the end of the year. Also Different level employees
accumulate vacation time @ different rates (i.e.: .67 days per month, .83
days per month, or 1.33 days per month).

I understand that I will have to input the different vacation rates for each
employee and work the hire date into the calculation. But because of the use
of the dates and the other parameters above I have gotten myself totally
lost. I found the following web page:
http://www.cpearson.com/excel/datetime.htm#AddingTimes hoping that it would
help me. But it has only confused me more. I was hoping this would be simple
problem .... guess not.

Thx in advance,

Steve