calendars

[gary kropp]

Can anyone tell me how to link a dropdown calendar to a
cell in an excel spreadsheet. I need it to return a
selected date from calendar to cell.

 

[Andy Brown]

Can anyone tell me how to link a dropdown calendar to a

cell in an excel spreadsheet. I need it to return a
selected date from calendar to cell.

#1
Using the "Control ToolBox" toolbar, you should be able to place a Calendar
control on your worksheet (via the "More Controls" button). Once it's on
there, you can use the "Properties" button to set its "Linked Cell" prop to
e.g. "Sheet1!A1". But I dunno if this'll count as a "dropdown calendar" (?)

#2
"=TODAY()" in A8 ; "=A8-1" in A7, drag this up to A1. "=A8+1" in A9, drag
this down to A14.

Then for *the* cell, use A1:A14 as the source for a data validation list.

HTH,
Andy

 

[Bob Phillips]

Ron has plenty of details and examples on his site

http://www.rondebruin.nl/calendar.htm

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)