ms office - Microsoft Excel Array Formula with dates -

ms office - Microsoft Excel Array Formula with dates -

i need next array date type:

=if(or(a2:c2="mar 12"),1,0)

sample info https://docs.google.com/spreadsheet/ccc?key=0ahodu0otm87sdhr3rgw3ntjacev1oet5owztwtbyufe&usp=sharing

looking @ sample data, in column e want array formula columns b d , search results contain 'may 12' , display true or false (1 or 0) in column e.

i think meet needs - type in d2:

=if(sum((month(a2:c2)=5)*(year(a2:c2)=2013))>0,1,0)

but press ctrl+shift+enter instead of usual enter - define array formula , result in {} brackets around (but not type them manually!).

specify month , year wish)

excel ms-office