Excel treats dates a serial values no matter how they are formatted. So in your example 24-Jan-03 is actually 37645 to excel. If you want to compare by month day or year you might add columns to your data with month function, day function year function etc. or combinations thereof. Good Luck.