Link or paste cells based on Date in cell

A

Ayanna

Please advise whether the following is also possible.
I have the following formula in cell B52:
=IF(WEEKDAY(TODAY(),2)=5,TODAY()+1,IF(WEEKDAY(TODAY(),2)
=1,TODAY()-2,""))
Is there a single formula that will paste/link the value
(TIME)of cell D2 into cell D53 if the value (DATE) in B52
is Dec 6; and paste/link the value(TIME)of cell D12 into
cell D53 if the value (DATE) in B52 is Dec 13; and
paste/link the value (TIME) of cell D22 into cell D53 if
the value (DATE) in B52 is Dec 20; and paste/link the
value (TIME) of cell D32 into cell D53 if the value (DATE)
in B52 is Dec 27; and leave cell D53 blank if cell B52 is
displaying a blank due to non-friday/non-monday print date?
Cell D53 and others are the 'running' daily record of
hours worked...they are linked to a worksheet (Weekly
Timesheet) which is ultimately printed on a Friday or
Monday...if no single formula works, is there a macro or
something that can be used???
Thanks again!
 

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

Should I Give Up? 3
Search closest day in the past from today 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Function based on blank cell and date past due 11
Multiple Challenging Excel needs.... 0
Running total based upon current date 5
formulas to count dates 2
Update cell value based on name and specific date 0

Top