Convert date to number representing Month

K

Karin

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?
 
R

Ron Coderre

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)
 
S

Stonecutter

I have tried that...I think my problem is that i am entering dates
(manually), and then need the months for a pivot table sort. I know i have
done this b4, but I just can't sort this out. It is late and after a long
day, week ;-).

Kevin B said:
In A2 put the following function:

=MONTH(A1)


--
Kevin Backmann


Karin said:
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?
Click to expand...
Click to expand...
 
S

Stonecutter

Hey bud, I found the answer I needed below; thanks anyway.

Kevin B said:
In A2 put the following function:

=MONTH(A1)


--
Kevin Backmann


Karin said:
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?
Click to expand...
Click to expand...
 
Top