Extract the Month from a cell with a formatted date

[Alcadia]

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?

 

[Fred Smith]

There are a few ways, like:
=month(ad7)
=text(ad7,"mmm")

Regards,
Fred

 

[מיכ×ל (מיקי) ×בידן]

Try the: MONTH function.
Micky

 

[Gary''s Student]

With a date in A1, in another cell enter:
=MONTH(A1)