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.
Bookmarks