Have 2004 and 2005 dates in worksheet

[Mark Christensen]

Hello,

I've got Excel 2002 SP3. I have an ad schedule that lists closing dates for
2005 magazines. Some of the early 2005 issues (January and February) close
in November and December 2004. March and subsequent issues close beginning
in January 2005. I put the closing dates in the cells as 11/16 and 12/16
for Jan-Feb and it automatically adds the 2004. When I enter 1/16, I want
it to add 2005 instead of 2004. Can this be done? Thanks.

 

[Debra Dalgleish]

If you type only the month and day, Excel assumes the current year, as
described in the following MSKB article:

http://support.microsoft.com/default.aspx?id=214391

You may be able to use programming to help with the date entry. Chip
Pearson has information on his web site:

http://www.cpearson.com/excel/DateTimeEntry.htm