Determining all the weekdays of a month

[Blondie96]

(I put this in the wrong forum, so I'm posting it here, where it belongs)

I need to produce a list of the dates (i.e. 4/18/05, 4/19, 4/20, 4/21, 4/22...)
of the weekdays of a month I pass as a variable.

Does anyone know how I could produce this?

Thanks

Tamra

 

[snotmare]

Hello Blondie96!

Try this...

MsgBox DatePart("W", "04/19/2005")

This will return 1 - 7, so you can then do an evaluate statement or something to determine the text value for the week day.

Good luck!

He who has knowledge spares his words, and a man of understanding is of a calm spirit. Even a fool is counted wise when he holds his peace; when he shuts his lips, he is considered perceptive. - King Solomon