Try this:

A1: Today()
A2: =MONTH(A1)

Does that help?
Post back if you have more questions.
--------------------------

Regards,

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

"Karin" wrote in message
...
Hi,
If I have a date [NOW()] in Cell A1, I want to put a number representing
the
month in A2 (for July, the number would be 7). This is so I can multiple
by
the quantity of months. How can I accomplish that?