Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Auto Add Vacation

  1. #1
    Guest

    Default

    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?

  2. #2
    Board Regular jss1234's Avatar
    Join Date
    May 2004
    Location
    PA - USA
    Posts
    434
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Auto Add Vacation

    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.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Phoenix, Arizona
    Posts
    1,711
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Auto Add Vacation

    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?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •