Object Calendar 11.0
 

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.

Object Calendar 11.0
 

Pat

On this particular workbook you have the 1904 date settings which add 4 years
and 1 day to your computer date.

Excel normally uses the 1900 date system.

ToolsOptionsCalculation. Uncheck 1904 Date System.


Gord Dibben MS Excel MVP



On Tue, 9 Jan 2007 13:19:01 -0800, Pat wrote:

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.