=IF(AND(D2="BBC",OR(WEEKDAY(F2)=1,WEEKDAY(F2)=2)), "Met","Missed")

which is met if a Sun or Mon and BBC.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"dinadvani" <u22798@uwe wrote in message news:6174fe41e5286@uwe...
Hi all,

I require your help on this :-

I have an excel sheet where column D has one criteria and Column F
another.
Now I would like to have the below results

For instance if column D has value "BBC" and Column F has date which is
less
then Tuesday then in Column G it should display as "Met" else "Missed"

Note : Column D has different values such as BBC, ABC, NMF etc

Kindly help me with this

Thanks,
Dinesh