For Rick Rothstein

R

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
 
G

Gord Dibben

See my reply at your original thread.

Best to stay with one thread for continuity and clarity.


Gord Dibben MS Excel MVP
 

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

Top