VLOOKUP for day and month

[nicolaforni]

Hi,

I have some dates in range A1:A400.

Date format is like 20/03/2012

I would like to do a VLOOKUP or whatever other excel function in cells B1:B400 so that if the date has 20/03, 20/06, 20/09 or 20/12 then I get a value of 1 otherwise 0.

How do I do that?

[Andrew-R]

Duplicate post, sorry.

[Andrew-R]

In cell B1:

=IF(AND(DAY(A1)=20,MOD(MONTH(A1),3)=0),1,0)

Should do it.

[nicolaforni]

Thanks!