S
Stan Brown
(Excel 2003)
When I enter e.g. 12/30 in a cell, Excel interprets that as the date
2007-12-30, as expected. But when I enter 1/6, Excel interprets that
as last January, not next week.
Is there any way to tell Excel that dates before a certain date in
the year should be interpreted as next year, not this year?
When I enter e.g. 12/30 in a cell, Excel interprets that as the date
2007-12-30, as expected. But when I enter 1/6, Excel interprets that
as last January, not next week.
Is there any way to tell Excel that dates before a certain date in
the year should be interpreted as next year, not this year?