One way

=IF(WEEKDAY(A2,2)<6,A2,A2-WEEKDAY(A2,2)+8 )

with your date in A2

--


Regards,


Peo Sjoblom

"cmatera" wrote in message
...
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