Thanks fro the advice folks, but neither of those solutions have worked. I have attached the offending original spreadsheet. Column E is the one that is giving me problemsaugust 1 - 6.xlsaugust 1 - 6.xls