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?

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?

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?

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