vacation tracker
Im working on a vacation tracker, so far I have €śstart date€ť, €śtodays
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 wouldnt mind sharing?
|