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
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