| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert date to number representing Month
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert date to number representing Month
In A2 put the following function:
=MONTH(A1) -- Kevin Backmann "Karin" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert date to number representing Month
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert date to number representing Month
One way:
A1: =TODAY() A2: =MONTH(A1) In article , Karin wrote: 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert date to number representing Month
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" wrote: In A2 put the following function: =MONTH(A1) -- Kevin Backmann "Karin" wrote: 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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert date to number representing Month
Hey bud, I found the answer I needed below; thanks anyway.
"Kevin B" wrote: In A2 put the following function: =MONTH(A1) -- Kevin Backmann "Karin" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert a month-date format to day number of the year? | Excel Worksheet Functions | |||
| how to convert whole numbers representing seconds to mm:ss | Excel Worksheet Functions | |||
| Function or formula to convert "text" month to number of month? | Excel Discussion (Misc queries) | |||
| Function or formula to convert "text" month to number of month | Excel Discussion (Misc queries) | |||
| Need a stacked bar chart with each stack representing a month | Charts and Charting in Excel | |||
Linear Mode
