vacation tracker

[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?

 

[RRyan]

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.