Hi everyone I want to populate a cell with the value of another
cell..based on the following criteria:

If the first of the month is a Mon-FRI then the cell gets populated on
the date in the week which the first of the month falls on...example:
if 8/1/08 were a wed the field would get populated

UNLESS

If the first of the month were a Sat..like 11/1/08... if the first is
on a sat...then the field would get populated on the following monday
(11/3/08)

Any ideas? Thanks again!

Chris