Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calendar control for week day
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:B |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calendar control | Excel Discussion (Misc queries) | |||
Calendar Control | Excel Worksheet Functions | |||
Tie a Calendar week to a Scoped Projected Week | Excel Worksheet Functions | |||
Calendar Template with week numbers | Excel Discussion (Misc queries) | |||
How do I make a one-week calendar? | Excel Discussion (Misc queries) |