|First, a posting tip...|
If you click on the blue line at the bottom of this post, you can read the instructions on how to post data in this forum so that the columns line up and your data is easier for us to read. It may take some trial and error via the Preview screen, as explained in the instructions, but it can be done.
Second, you told us what you want if the date to be checked has past or is the same as TODAY(), but you didn't tell us what you want if the date is later than TODAY().
I assumed you want a blank cell.
2 Due Date Status
3 4/12/2014 =IF(A3<$A$1,"Late",IF(A3=$A$1,"Due",""))
4 4/21/2014 =IF(A4<$A$1,"Late",IF(A4=$A$1,"Due",""))
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03