Filling in a cell based on another cells date criteria

C

cmatera

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help to Highlight Excel Row based on Weekly Date Range 2
Auto populate value from one task to another in MS PROJECT 0
Link a text box based on drop down box with four options MS Word 365 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Populating a cell based on a specific date/combo 2
Linking Cell based on Date 8
Count cells containing specific text when adjacent cell contains datewithin a range... 4
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3

Top