Should I Give Up?

  • Thread starter Thread starter Ayanna
  • Start date Start date
A

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
 
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.
 
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.
 
Back
Top