I was wondering if anyone has ever wrote an excel formula that calculates vacation days based on an anniversary date with possible rollover days?
I tried everything I can think of. I'm using example below. I need to take the (Ann.Date) compare it the current date, and determine if there should be a vacation allotment an if so then add it to (days remaining until 12/31), then place that value the last column (Total Days Remaining for Calendar Year).
If the Ann. Date has not been obtain yet then i need to reference (Days Remaining) in the last column (Total Remaining for the Calendar Year). I would appreciate guidance or advice that anyone can give.
TX
Rob
Anniversay Date Shift Vacation Allotment Days Taken Days Remaining until 12/31 Total Remaining for the Calendar Year 2/14/1982 0 15 0 15 30
I tried everything I can think of. I'm using example below. I need to take the (Ann.Date) compare it the current date, and determine if there should be a vacation allotment an if so then add it to (days remaining until 12/31), then place that value the last column (Total Days Remaining for Calendar Year).
If the Ann. Date has not been obtain yet then i need to reference (Days Remaining) in the last column (Total Remaining for the Calendar Year). I would appreciate guidance or advice that anyone can give.
TX
Rob
Anniversay Date Shift Vacation Allotment Days Taken Days Remaining until 12/31 Total Remaining for the Calendar Year 2/14/1982 0 15 0 15 30
