+ Reply to Thread
Results 1 to 3 of 3

Determine future dates based on selected days of the week

  1. #1
    Registered User
    Join Date
    04-30-2008
    Posts
    9

    Determine future dates based on selected days of the week

    I'm trying to build a macro that once a user selects a start date (in cell A1) and days of the week in which they will work (from check boxes, sunday through sat corresponds to B20 through H20 (true if checked, false if not)) it will determine the next 5 days and insert them into cells B1 through F1.

    For example: If I select 5/25/08 as my start date, and check Monday, Wednesday, Friday. Once I run the macro it should put 5/26, 5/28, 5/30, 6/2, and 6/4 in cells B1 through F1, respectively.

    Any ideas?

    Thanks for the help.

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Hi

    See how this goes.

    Please Login or Register  to view this content.
    rylo

  3. #3
    Registered User
    Join Date
    04-30-2008
    Posts
    9

    Thanks

    It doesn't work perfectly, but I'll be playing with it over the next few days to figure it out. It might be that my check boxes aren't ordered correctly.

    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1