Should I Give Up?

[Ayanna]

Hi...I've been trying for hours, every possible formula
within my limited grasp...I don't want to give up until
told it cannot work:
With the following formula in cell B52:
=IF(WEEKDAY(TODAY(),2)=5,TODAY()+1,IF(WEEKDAY(TODAY(),2)
=1,TODAY()-2,""))

I want to automatically: display the value (TIME)of cell
D2 in cell D53 if the value of B52 is Dec 6; display the
value(TIME)of cell D12 in cell D53 if the value of B52 is
Dec 13; and leave cell D53 blank if cell B52 is
displaying a blank due to non-friday/non-monday print date?

If it is impossible and you know where something similar
has been done before, even if it is more complex, i would
like that formula to experiment with.

Thank you

 

[Norman Harker]

Hi Ayanna!

I think that this meets your specification:

=IF(B52="","",IF(B52=DATE(2003,12,6),D2,IF(B52=DATE(2003,12,13),D12,""
)))


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Ayanna]

OHMYGOSH! It works! It's perfect...I wasn't even Close!!!
Thanks Norman!

 

[Norman Harker]

Hi Ayanna!

Good to hear it works OK but I'm not so sure it was the most efficient
way.

=IF(B52=DATE(2003,12,6),D2,IF(B52=DATE(2003,12,13),D12,""))

It would do the same?


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.