If date is in the month of Sept, then "1", otherwise "2"
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!
|