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