How do I calculate date completed late =1
for example
due date = 01/03/2012
date completed = 28/02/2012
IF True return 1, IF false return 0 and ignore IF date completed cell is blank
I've tried this but only works if the months are the same and does not work if the month completed is earlier than the due date month
=SUMPRODUCT((DATE COMPLETED>DUE DATE)*(DATE COMPELETED<>"N/A")))
for example
due date = 01/03/2012
date completed = 28/02/2012
IF True return 1, IF false return 0 and ignore IF date completed cell is blank
I've tried this but only works if the months are the same and does not work if the month completed is earlier than the due date month
=SUMPRODUCT((DATE COMPLETED>DUE DATE)*(DATE COMPELETED<>"N/A")))