Nevermind I figured it out and added a column for my max carryover days and
changed the formula from Min(10,F2) to Min(Cell with Carryover,F2).

Thanks so much for your help
--
cao


"srctr" wrote:

Okay I think this is working well for the fulltime employees. I have people
who do not work 40 hrs a week, so that get a portion of the 10 days, 15 days
and 20 days of vacation. I noticed in the formula for Accrued Vac you have
c. Is this the minimum number of days that can be carried over
each year?
--
cao


"Ron Rosenfeld" wrote:

On Thu, 12 Feb 2009 12:10:15 -0800, srctr
wrote:

I will try this. I have 2003 but the company who is using this has 2007.
But I like the spreadsheet option.

--

Of the methods I've posted, I believe this last spreadsheet version, with the
helper columns, to be the most accurate, robust, and easiest to maintain.

Let me know.
--ron