![]() |
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 |
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 |
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