I know this thread is old (2004) but I'm also looking for a way to add
hours like "JOPLA" in a vacation tracking spreadsheet. Do you still
have this file that you could send to me? Thanks.

McCarthy_MF Wrote:
> Not knowing what exactly you are tracking or how you have it layed out
> the
> best I can offer is that you need a multipart calculation. First, you
> need a
> =today() formula to calculate when, in your example, Dec 10 is.
> Then, in your example, in cell A1 you need to have an IF statement to
> measure against your =today() formula for the Dec 10 date.
>
> IF this is helpful but not helpful enough please let me know. I know
> with
> the file in front of me I can build it, I have one for my personal
> tracking
> that calculates my hourly acrual of vacation time, makes the adjustment
> to
> the rate for my anniversary, and accounts for how much I have taken.
> I'd be
> happy to share my file so you can get an idea on how I tackled this.
>
> "jopla" wrote:
> -
> I am using a vacation tracker spreadsheet to record vacations used. On
> an
> employee's anniversary date, they have vacation time added. Can I
> create a
> formula that will add their newly allowed vacation time to a cell, on
> their
> anniversary date?
>
> Example. On December 10 add 10 days (or hours or shifts) to Cell A1.
> Thanks....-



--
tls