Convert date to number representing Month

  • Thread starter Thread starter Karin
  • Start date Start date
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?
 
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)
 
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...
 
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...
 
Back
Top