Extract dates for specific days in a date range

**Ricker090** · 12-13-2011, 04:24 PM

I have a date range, 1/1/2012 to 1/24/2012. In this date range I would like to create a list of all the dates that fall on Monday and Tuesday. Any ideas on how to do that in VBA?

**TMS** · 12-13-2011, 04:39 PM

One way:

Please Login or Register  to view this content.

Regards, TMS

**tom1977** · 12-13-2011, 04:40 PM

try this:

Please Login or Register  to view this content.

start day cell A1
end day cell B1

**Ricker090** · 12-13-2011, 08:20 PM

Thanks!! They both work great.

**TMS** · 12-13-2011, 09:36 PM

You're welcome. Thanks for the rep.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save