Originally Posted by Spencer101

Dates in formulas don't work that way. You'd need to specify it as a date, then describe the year, month and day to get it to work.

An easier way would be to replace the dates in your formula with the 5digit numbers that Excel uses to interpret dates or put the dates in cells elsewhere and refer to those.

If you post an example workbook I'll happily show you how.

It may be that there's actually a better way to accomplish this than with a nested IF.

S.