Thanks Bob

but there are many conditions so how do i enter it in excel

BBC is one criteria wherein is this report is submitted on or before tuesday
then it shld display "Met" else "Missed"

But as i said there are many report say "ABC", "XYZ", DDL" etc if this report
is submitted on or before wednesday then it shld display "Met" else "Missed"

can we do something as in if BBC is submitted on or before tuesday then Met
or Missed and all the reports other than BBC if submitted on or before
wednesday then Met or Missed

Thanks for your help

Dinesh
Bob Phillips wrote:
=IF(AND(D2="BBC",OR(WEEKDAY(F2)=1,WEEKDAY(F2)=2)) ,"Met","Missed")

which is met if a Sun or Mon and BBC.

Hi all,

[quoted text clipped - 12 lines]
Thanks,
Dinesh

--
Message posted via http://www.officekb.com