For Rick Rothstein

[retired bill]

Hope this gets to you, it was yesterday I posted, but had to wait until now
to get back with you------scroll down

MY QUESTION>
I figured out how to add a calendar control to my excel spreadsheet.
YOUR ANSWER
You can use the TEXT function to return the day name directly (and without
the need for the Analysis ToolPak)...

=TEXT(B7,"dddd")

Rick (MVP - Excel)

MY NEXT QUESTION>

Rick, thanks for your answer. This is a very simple answer to this question,
however, when I insert the formula, then copy and paste for the range in the
column, it displays the SAME day of the week for the entire column, until I
use the calendar control and actually click on a date I have picked. I would
like to have the cell return a BLANK, until I use the calendar control and
click on a date, then enter the correct DAY of the week in the cell.

Thanks for your time, Bill

 

[Gord Dibben]

See my reply at your original thread.

Best to stay with one thread for continuity and clarity.


Gord Dibben MS Excel MVP