Looping through day of week

**JP Romano** · 03-17-2009, 02:29 PM

Hi all...
I'm trying to set up a simple macro to loop through some number of dates on a sheet and blank out fields next to every instance of Saturday and Sunday.

The only problem I'm having is actually finding the values "Saturday" and "Sunday"

Given a date in this format: 01/01/2009
I can convert to "Thursday"

Problem is, the vba code still "sees" 01/01/2009

I've tried copy / paste special / paste values to no avail.
I've tried changing it via VBA (a few different methods, including strings, formats, etc) with no luck.
Even tried referencing my date cells from another spreadsheet and pasting the values back in. Can't seem to get 01/01/2009 to be "Thursday"

I'm sure I'm missing something pretty simple. Can any of you smack some sense into me?

Thanks

**DonkeyOte** · 03-17-2009, 02:51 PM

You can use something like

Please Login or Register  to view this content.

**Charles** · 03-17-2009, 03:11 PM

Just another sample

Please Login or Register  to view this content.

**JP Romano** · 03-17-2009, 03:34 PM

Donkey / Charles... ah, thanks. Very helpful and, of course, successful.

You guys are as generous with your time as you are knowledgeable on the subjects on hand.