Why not start with an Excel file pre-populated with the date of every pay day on its own row. Find a copy of the pay schedule on the intranet and copy/paste. Fill column C (Change) with 5.

Column F (Vtime Total) would be a running total. ie: F4 is =F3+C4. When you want to take off 4/8/08, just insert a new row 8. Excel will fill F8 with the running total formula. In C8, enter -8.

This would require separate Change columns for FHoliday, SickTime, and Vtime. Instead, Change could be purely numeric and the preceding column could be "Type" to indicate which of the three off times. The running totals could use an IF to check Type and see if the value in Change applies to them or not.

But you probably knew this, because no questions on this BBS are actually easy enough for me to answer.