question on populating date/day of week from source cell

**sconniestyle** · 03-17-2009, 01:12 PM

hi excel wizards.

i know that as a brand new member of a forum it is bad form to create a thread right out of the gate, but i need excel help to finish a project at work by the day's end, so internet protocol be damned.

here is what i am trying to do.

i need to know how to set up a sheet so that when i enter the weekday name and date of the month's first workday, it auto populates the rest of the month in weekday names and dates throughout the sheet.

i.e. if i enter "mon" in cell A2, i need cells A6-A36 to auto populate with the corresponding days of the week until the end of the month (excluding sat and sun)

if i enter 4/1/2009 in cell B2, i need cells B6-B36 to auto populate with the corresponding weekday dates (excluding weekends) until the end of the month as well.

i hope someone can find it in their hearts to help a fairly noobish excel user out.

**Greg M** · 03-17-2009, 08:06 PM

Hi there,

See if the sample in the attached workbook meets your requirements.

Hope this helps - please let me know how you get on.

Regards,

Greg M