This should get you going in the right direction:

=IF(WEEKDAY(C1)=7,C1+2,IF(WEEKDAY(C1)=1,C1+1,C1))


This tests the weekday value of the date in C1 - if it is Saturday(7) it adds
2 days to C1, a Sunday (1) adds i day elase it accepts the date.

I think that you need the analysis pack to use the expression weekday

edvwvw

cmatera wrote:
I want to populate a cell with the value of another
cell..based on the following date criteria - My date cell is stored in
(F5) and the cell I want to populate (D20) has a value stored in (C20)

If the first of the month is a Mon-FRI then the cell (D20) 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 (D20) would get populated with the
value in cell (C20)

UNLESS

If the first of the month were a Sat..like 11/1/08... if the first of
the month falls on a saturday
on a sat...then the field (D20) would get populated with (C20's) value
on the following monday
(11/3/08)

This is a really pesky problem - but any help is appreciated
Thanks

--
Message posted via http://www.officekb.com