I have been using Calendar 11.0 in my excel spreadsheets with no problem, but
am setting up a new worksheet which I have added the calendar to. When I
click on the cell and pick a date it gives me the next day as the date and
not the current day which I clicked on in the calendar.

Example: On the calendar which is set for 2007 I click Jan. 9th, the date
that shows up in the cell is 1/10 and then if I have it set to show the year
the date comes up 1/10/2011.

Please help! I can't figure this one out, and it's probably something very
simple.