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