Excel 2007 : Need vba code to determine is year is odd or even

[BigGPL]

Hi all,

In the attached file when a new date is entered in the userform, Sheet1 C3-C206 is populated with the weekdays except for Sundays.

What I would appreciate if someone could add some coding to the userform code that would check if the year in C3 is even then E3 = EVEN else E3 = ODD

Just a note on my coding. The date entered in the userform will always be on a Monday, ie, 1/10/2011, 1/9/2012, etc that is why I coded the way I did to skip Sundays.
Since I'm relatively new at this, this is what I came up with. It took me two hours to get it working.

Thanks in advance,

George

[davesexcel]

Try,

=IF(YEAR(C3)/2=INT(YEAR(C3)/2),"EVEN","ODD")

There is also an =iseven() function, you may have to use the analysis toolpack add-in for that.

[DonkeyOte]

George, perhaps:

Please Login or Register  to view this content.

though I'd make the point that you don't really need a userform for this - you could just use formulae (with validation in C3) or VBA wise use Application.InputBox (type 1)

[BigGPL]

Hey Guys,

Thanks for the replies, really appreciated.

DonkeyOte,

Went with your method. I do have a question, however. When you have a few extra minutes could you please explain the following code that you used

Please Login or Register  to view this content.

I don't even know where to begin in deciphering the above.

Thanks,

George

[DonkeyOte]

You don't have to use R1C1 notation if you prefer to use A1 notation (force of habit on my part)

Please Login or Register  to view this content.

note use of .Formula rather than .FormulaR1C1

[BigGPL]

You don't have to use R1C1 notation if you prefer to use A1 notation (force of habit on my part)

Please Login or Register  to view this content.

note use of .Formula rather than .FormulaR1C1

Simpler coding, Thanks for the help

George