vacation tracker

  • Thread starter Thread starter RRyan
  • Start date Start date
R

RRyan

I’m working on a vacation tracker, so far I have “start dateâ€, “today’s
dateâ€, “days360â€,
“=IF(D5<360,"0",IF(D5<720,"5",IF(D5<1800,"10",IF(D5<3600,"15",IF(D5>=3600,"20","")))))â€
(returns the number of days earned.) “days usedâ€, “days leftâ€. Is there a
way to get excel to add the correct number of days to the available days on
the anniversary date? Or does someone already have a vacation tracker made
that they wouldn’t mind sharing?
 
Thanks for the first suggestion it works great. What I'm trying to do is
track Vacation time. If an employee has time left to take on his/her
anniversary I would like to have the proper number of days added to the days
left. I can't find anything to suggest that excel will do this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vacation Tracker 2
Date Vacation Tracker 5
Leave Tracker 2
Somewhat Complex: Allocation of Payments 7
Using workday function to populate schedule 2
loop through rows 1
formula--if/then 3
Do I use a formula or a macro to copy cells? 3

Back
Top