That does help, thanks.

I've modified it to this: =IF(MONTH(N10)=A5,N20,M20)

So if the month in cell n10 equals today's month (in cell a5), then use the
data in cell n20, otherwise use next month's data which is in cell m20.

I will probably have a bunch of nested Ifs where M20 is, becuase I have to
reference a few date ranges.

Thanks very much Ron!

"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!