I entered a new worksheet at the end of the workbook called END. Use this as a template and enter all new sheets between the summary and the end and the calculations in the summary sheet will not have to be changed.
I would use a different code for vacation time in the future as those are only planned times and not times actually taken. All V values in the future, I changed to PV (Planned Vacation). Change PV to V when the vacation actually happens. Doing that will allow you to use a summary formula in column C if and only if the names remain in the same row. Enter this in column C and copy down:
Formula:
=IF(A6="","",SUM('2012 Q3:END'!C6))
Enter this in G6 and copy down:
Formula:
=IF(A6="","",IF(TODAY()>=DATE(YEAR(E6)+5,MONTH(E6),DAY(E6)),15,IF(TODAY()>=DATE(YEAR(E6)+4,MONTH(E6),DAY(E6)),10,IF(TODAY()>=DATE(YEAR(E6)+1,MONTH(E6),DAY(E6)),5,))))
Bookmarks