Display proper date on Saturday

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

.. In Column B, Rows 5 - 25 are dates formatted as 3/15/08
.. In Column A, Rows 5 - 25 are days formatted as m/d using a formula
=IF(B9="","",TEXT(B9,"ddd")) resulting in Mon, Tue, etc. when a date is
placed in Column B
.. In Cell Q6 is Mon, Cell Q12 is Tue, Cell Q18 is Wed, Cell Q24 is Thu, Cell
Q30 is Fri, Cell Q36 is Sat, Cell Q42 is Sun
.. In Column R, in the Cells adjacent to the text Cells in Column Q is the
formula {=INDEX(B$5:B$25,MATCH(Q6,TEXT(B$5:B$25,"ddd"),0))}

The result is if a date such as 9/5/08 is typed into Cell B5 then Cell A5
displays "Fri" and Cell R30 displays "9/5/08".

This functions perfect with the exception of Cell R36, which is adjacent to
the text "Sat" in Cell Q36. The date displayed in this Cell is always
1/0/00

Is there a way of expressing the proper date on Sat (Saturday)?

Regards,
Gary
 
Works fine for me, shows 6/9 perfectly.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top