[SOLVED] Work Out If Finish Date/Time is Late - Excel 2003

Apologies if this is covered elsewhere - I've searched but can't find anything that does exactly what I'm trying to do.

I have two columns - DUE_DATE and DATE_FINISHED. Each cell (or at least most cells, some are blank in the DATE_FINISHED column) contains data formatted as 'dd.mm.yyyy hh:mm' What I'm trying to work out is how to tell which records are late, i.e. if the DATE_FINISHED is greater than the DUE_DATE. I thought I'd be able to use a standard IF, but it doesn't seem to work. I could do it by looking, but I'm getting on a bit and my eyes aren't what they used to be! To be serious, if I get it right this time I might have to do it more often and with more records, so any time saving solution would be great! I've attached a workbook as an example.

Dave

Hello Dave, you can use this formula in C2 copied down the column

=IF(AND(B2<>"",B2>A2),"Late","")

That takes the times into account, if you only want it to be "Late" if the date is later change to

=IF(AND(B2<>"",INT(B2)>INT(A2)),"Late","")

Perfect! Thanks for your help.