Quote Originally Posted by Dav
well the dates in your sheet are not trully dates, if you format them to a number format do they change or stay the same. If they are text, it would be better to change the spreadsheet, but if you wish i can come up with a formula

Regards

dav
If I format the text to date it changes from 7/15/2006 to 7/15/06. What would you suggest?