Calculating Time by Month

[Guest]

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.

Any suggestions?

Thx in advance,

Steve

 

[Guest]

Hi Steve

Sadly no specific advise to give - just general advise that I use when
planning a spreadsheet application

Break it all down into smaller processes - that way they are easier to work
with
as an example to begin with keep your employee start dates separate to your
vacation accrual - ie separate worksheets could work here.

On each work sheet - calculate only the needed infor to do with that topic.

Finally you can start linking all the seperate info together into the final
solution

HTH