dates older than 1900
 

how can I sort dates older tha 1900? In an ascendent sort, Excel order them
at the end, and it fails too calculating amount of days elapsed

dates older than 1900
 

See this web site:
http://www.j-walk.com/ss/excel/usertips/tip028.htm

Regards,
Ryan--

--
RyGuy


"P Boric" wrote:

how can I sort dates older tha 1900? In an ascendent sort, Excel order them
at the end, and it fails too calculating amount of days elapsed

dates older than 1900
 

Thanks, they have an add-in, I downloaded it, and worked fine. now, I am able
to calculate the day of the week and other formulaes.
In order to sort a mixed list of dates, before and after 1900, I had to
separate the dates first in year, month and day, and then perform a complex
sort

"ryguy7272" wrote:

See this web site:
http://www.j-walk.com/ss/excel/usertips/tip028.htm

Regards,
Ryan--

--
RyGuy


"P Boric" wrote:

how can I sort dates older tha 1900? In an ascendent sort, Excel order them
at the end, and it fails too calculating amount of days elapsed