If certain date is past certain date.

[Angela1979]

Hi everyone.

I have the following problem if you guys could please help me

Two colums , as below

A
B C
1 Due Sent
2:
3: 15 Jan 07 16 Jan 07
4: 10 Dec 06
5: 11 Dec 06
6: 12 Dec 06 13 Dec 06
7: 24 Nov 06

I need a formula to advise SLA missed or SLA met.
If Sent date is after due date then - SLA Missed
If Sent date is before due date or on due date - SLA Met


I have tried the following
=IF(B1>=A1,"SLA Missed",IF(B1<=A1,"SLA Met",IF(A1="","",(IFB2="",""))
This shows a mixture of SLA Missed and SLA Met for cell containing one
or both dates.


Thanks all

 

[Toppers]

Try:

=IF(AND(B1>=A1,B1<>""),"SLA Missed",IF(AND(B1<=A1,B1<>""),"SLA Met",""))

HTH

 

[Teethless mama]

=IF(OR(A1="",B2=""),"",IF(B1>=A1,"SLA Missed","SLA Met"))

 

[Angela1979]

Excellent thanks very much everyone