I have three colums in a worksheet, one tells a documents due date, the other tells the date it was turned in and the third contains a formula that states whether the document was ontime or not. THe due-date coloumn contains not only dates, but some cells which are filled in "ASAP" - so the formula I need for the 'on-time' column must also include this ASAP. I am trying to set up the formula to says "yes" or "no" according to dates and "Rushed" if the Due column says ASAP.

Here is what I have been trying to work withbut keep getting errors
=IF(C6<D6,"Yes","No",IF(D6="ASAP","RUSHED"))