Date function

[Craig]

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]

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