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?