| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract the Month from a cell with a formatted date
I have a cell AD7 with a formatted date "dd/mmm/yyyy" to count orders and i
need to count how many orders for each month. how do i count MMM as 1 to another column? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extract the Month from a cell with a formatted date
There are a few ways, like:
=month(ad7) =text(ad7,"mmm") Regards, Fred "Alcadia" wrote in message ... I have a cell AD7 with a formatted date "dd/mmm/yyyy" to count orders and i need to count how many orders for each month. how do i count MMM as 1 to another column? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extract the Month from a cell with a formatted date
Try the: MONTH function.
Micky "Alcadia" wrote: I have a cell AD7 with a formatted date "dd/mmm/yyyy" to count orders and i need to count how many orders for each month. how do i count MMM as 1 to another column? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extract the Month from a cell with a formatted date
With a date in A1, in another cell enter:
=MONTH(A1) -- Gary''s Student - gsnu201001 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract month from date | Excel Discussion (Misc queries) | |||
| EXTRACT MONTH FROM DATE | New Users to Excel | |||
| How can I extract a month from Excel date? | Excel Discussion (Misc queries) | |||
| How can I extract name of the LONG MONTH from previous cell. | Excel Worksheet Functions | |||
| extract the month of a date | Excel Discussion (Misc queries) | |||
Linear Mode
