for some reason the month function doesn't seem to work between links of
separate worksheets.

I changed the formula to this:

=IF(EOMONTH(Monthly!N10,0)=EOMONTH(A5,0),Monthly!N 20,IF(EOMONTH(Monthly!M10,0)=EOMONTH(A5,0),Monthly !M20,"xxx"))

and it works now, but if you know of a better way, I'd like to hear.

Thanks again.



"Ron Coderre" wrote:

Try this
=1+(MONTH(A1)<9)

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"SteveC" wrote in message
...

cell a1 = the date

a1 could equal 9/15/2007, 8/20/2007, 9/26/2007, 5/30/2006, etc.

formula please?:

if the date in cell a1 falls in the month of september, then "1",
otherwise
"2"

thanks very much!