Date function

Craig · Jan 9, 2007

I am preparing a time line in Excel 2003. I want the left column to reflect
the date and be sortable but I need two different types of dates. One might
be "July 4, 1776" or simply the year "1492".

thanks for any help...jcs

Gord Dibben · Jan 9, 2007

Craig

Excel does not recognize dates prior to 1900 so you must be entering July 4,
1776 as text.

Sorting will not take place as you wish.

For working with dates prior to 1900 see John Walkenbach's site.

http://www.j-walk.com/ss/excel/usertips/tip028.htm

Gord Dibben MS Excel MVP