It would help us to help you if you uploaded a sample workbook.

12/1 and 12/31 isn't necessarily a date, so we need to see what it is you are comparing against.


Regards, TMS