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.
Thanks for the help.
See how this goes.
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1