I figured out how to add a calendar control to my excel spreadsheet.
For example, when I click in cell B7, the calendar appears, I click on a
November 11, the date of 11/11/08 gets entered into cell B7, and the calendar
disappears. This works Fine. However, what I would like to be able to set
up
is when the person clicks on November 11, the date of November gets entered
into cell B7 AND the corresponding weekday (in this case, Tuesday) gets
automatically entered into the cell next to it, C7.
i.e. cell B7 returns the DATE
cell C7 retunrs the DAY of week
The calendar control is in column B - Range B7:B56

G'day

This is not too hard to do once you know. The WEEKDAY function will give
you a number that returns the day of the week e.g. "=WEEKDAY(B7)"

This actually gives you an integer in the range 1 to 7 (1 for Sunday, 5 for
Thursday etc etc). You can then use a VLOOKUP to link the integers to the
names of the days via a little table that you create in another part of the
sheet or file.

If you find that your Excel environment doesn't recognise WEEKDAY, you will
need to go to Tools --- AddIns and turn on the one called "Analysis Tool
Pack" (then close the file and reopen it).
--
Time is just the thing that keeps everything from happening all at once


"retired bill" wrote:

I figured out how to add a calendar control to my excel spreadsheet.
For example, when I click in cell B7, the calendar appears, I click on a
November 11, the date of 11/11/08 gets entered into cell B7, and the calendar
disappears. This works Fine. However, what I would like to be able to set
up
is when the person clicks on November 11, the date of November gets entered
into cell B7 AND the corresponding weekday (in this case, Tuesday) gets
automatically entered into the cell next to it, C7.
i.e. cell B7 returns the DATE
cell C7 retunrs the DAY of week
The calendar control is in column B - Range B7:B56