Populating a cell based on a specific date/combo

[cmatera]

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

 

[Peo Sjoblom]

One way

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

with your date in A2

--


Regards,


Peo Sjoblom

 

[cmatera]

I have dates in cells ranging from cell F5 being 07/28/08 all the way
to cell AG5 being 08/06/08

My Cell would get populated with a #...10 for example if the first of
the month falls on a Mon-Fri so for example my cell on 8/1/08 would
get populated with 10 if the first of the month fell on that weekday.
However, sometimes the first of the month falls on a sat or even a
sunday 11/1/08 being a saturday. If the first falls on a saturday I
wouldn't want my cell to get populated with 10 until the next monday
(11/3/08).

So I'm still confused as to applying the formula - any ideas?

It's much appreciated
-Chris




The cell needs