Auto Add Vacation

[Guest]

I have a worksheet with every date for the year on it and would like to have Excel add vacation time at the beggining of each month automatically, but not until each 1st of the month, how would I write this to happen each month automatically?

 

[jss1234]

Try to create an auto open VBA script that uses the excel day function and an iof statement that says if(day(today())<>1 then goto end, else run macro that accrues vacation.

 

[Travis]

I think this can be done without VB
can you use Colo's HTML tool at the bottom of the page to paste an example of your data.

Also how is vacation allocated? Spread evenly across the year so if you get 10 days a year and its 7/1/04 then the spreadsheet should say 5 days?