Date Vacation Tracker

[jopla]

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....

[McCarthy_MF]

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]

I would appreciate the file.

My Company awards all vacation earned on an employee's aniversary date. I am
using a template I downloaded from MS. The spreadsheet has a "rollup" sheet
that keeps track of vac days left.

There is a tab for each month. When a day is used (ex: Feb 14), one day is
decremented from the total left on the "rollup" sheet. I would like to have
the formula automatically add the vacation due. EG, Joe gets 3 weeks = 15
days on June 14. When June 14 rolls around, I want the rollup sheet to have
that vacation amt automatically added into Joe's vacation allowed.

Make sense??
Thanks

[McCarthy_MF]

Please send an email to my name as listed below @hotmail.com and I'll get a
copy of my file to you. Please use the subject of this string so I can look
for it in my Bulk/Junk folder and not delete it.

I'll also give it some thought for building a managers version of vacation
tracking, or at least one that is not based on the acrual rate system.

[Phyllis]

Hello,

If you wouldn't mind, I would love a copy of your tracking
spreadsheet. I've been trying for months to do exactly
what you said yours is does. Thanks.

>.
>

[McCarthy_MF]

Please send an email to my name as listed below @hotmail.com and I'll get a
copy of my file to you. Please use the subject of this string so I can look
for it in my Bulk/Junk folder and not delete it.

[tls]

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