Date Vacation Tracker
 

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

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

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

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.


"jopla" wrote:

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

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

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.

"Phyllis" wrote:

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

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.