Thanks so much. This is how I had written it =IF(D16=TODAY(),AMT DUE,OVERDUE!) Its giving me a #NAME error. I am typing out loud now but I think I know what I did wrong. If my date is not written in the same format as the TODAY() date produces would I get that error?