If statement help

[IrishHawg09]

Hello,

I'm trying to create an if statement that returns every other January. My current statement is "=IF(month(B1)=1,x,0)". This obviously returns a value every January, but as stated I only want every other January. Can this be done simply?

Thanks!

 

[steve the fish]

Something like:

=IF(AND(MONTH(B1)=1,ISEVEN(YEAR(B1))),x,0)

 

[ghrain22]

For Even Years:
=IF(AND(MONTH(B1)=1,MOD(YEAR(B1),2)=0),x,0)

For Odd Years:
=IF(AND(MONTH(B1)=1,MOD(YEAR(B1),2)=1),x,0)

Using the mod function you can look at the remainder of a division problem. So basically look to see if the year divided by 2 has a remainder of not.