ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Populating a cell based on a specific date/combo (https://www.excelbanter.com/excel-worksheet-functions/199591-populating-cell-based-specific-date-combo.html)

cmatera

Populating a cell based on a specific date/combo
 
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[_2_]

Populating a cell based on a specific date/combo
 
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




cmatera

Populating a cell based on a specific date/combo
 
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

On Aug 20, 2:50*pm, "Peo Sjoblom" wrote:
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




All times are GMT +1. The time now is 10:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com