Sorry, The month (April) will be placed into cell A1. The days of week will
start in cell B1 (M), B2 (T), B3(W), B4(TH), B5(F), B6 (M), B7 (T), etc. The
day of the month will be programmed into C1, C2, C3, etc depending on which
day of the first week it corresponds with.

So if A1 = April, and April 1st falls on the first Weds of the month, then
cell C3 would be equal to one (1). Hope this makes sense. I have a word
document that shows that shows the formatting better. If you would like an
email, let me know and I will send you my address.

"joel" wrote:

Can you explain a little better. We can't tell from your posting where any
of the data is located.

"Tony" wrote:


I have the following spreadsheet where I have to VBA code the cell with the
first day of the month with the corresponding day of the first week in row 3
using the recorded month as a reference point. For example April 1st of this
year fell on the Weds in the first Week.

April
A B C D E F G 1 M T W TH F M T 2 1

Can someone help out with some code? I am learning how to code VBA through
this site, but this one seems to be more difficult than I can do.