vba to autofill dates

[justmejeff]

Hi, i would like to create a macro which will fill in the dates of the
week. Monday, Tuesday, etc through Saturday. The cells are B4, D4,
F4, H4, J4, L4. It would be easy for me to use =Now() and then go
down the line and do =Now() +1, =Now()+2, etc but I would like the user
to be able to use the macro any date throughout the week and have it
work correctly. Is there anyway to do this? I appreciate the help.
Thanks. Jeff

 

[Myrna Larson]

If the user runs the macro on Tuesday, 23 Nov, what series of dates do you
want in the cells? Start Nov 22? Start Nov 29?

 

[justmejeff]

I would actually like it to start with 11/22/2004