Sometimes I need to carefully track my vacation time usage, since I travel to a lot of Sci Fi and Filk conventions and frequently run up against the bleeding edge of the number of hours I can take off in a given time period. I often need to plan these days far in advance, so simply looking at how much vacation time I've accrued *now* isn't useful, I need to know how much vacation time I *will have accrued* as of a date several months from now (including any time I may be planning on taking between now and then).

Perfect job for a spreadsheet, of course. I've been keeping track of it by hand so far, but a spreadsheet would be much nicer.

Does anyone know how to have Excel automatically insert rows and do accruals based on dates that are related to the position within a month? Let me be more specific. I want a row to automatically appear on the spreadsheet for the 15th day of every month, and for the last day of every month. That's when the vacation time accruals are processed: I accrue 5 hours of vacation time with each paycheck, or 10 hours per month, working out to 15 days per year.

A given section of my desired spreadsheet might look something like this:

Code:
   Date                  Event            Change       FHoliday Total  SickTime Total  Vtime Total
----------           -------------      -----------    --------------  --------------  -----------

2008 03 10            Consonance         Vtime -8            16           73.26             2     
2008 03 15            Accrue Time        Vtime +5            16           73.26             7
2008 03 21            Sick Day           Sick -8             16           65.26             7
2008 03 27            Sick Day           Sick -8             16           57.26             7
2008 03 31            Accrue Time        Vtime +5            16           57.26             12    

                                                                                                  
2008 04 03/04         FilkOntario        FHoliday -16        0            57.26             12    
2008 04 07            FilkOntario        Vtime -8            0            57.26             4     
2008 04 15            Accrue Time        Vtime +5            0            57.26             9     
2008 04 30            Accrue Time        Vtime +5            0            57.26             14


Is there any easy way to make the "Accrue Time" lines appear automatically in the spreadsheet?
_________________________
Tony Fabris