Use a helper column with =MONTH(A1) copied down
Copy PasteSpecial Values, then sort on the helper column.........

Vaya con Dios,
Chuck, CABGx3



"brewisc13" wrote in message
...
One more question: We have a range of birthdates, even when you format it
to
mmm, you cant sort by month. We want to find out the people in the ragne
whos
birthday falls in a given month.

"brewisc13" wrote:

THANK YOU! That worked great!

"Earl Kiosterud" wrote:

You could use a helper column, with something like = A2. Format this
(Format - Cells - Number - Custom: mmm. Now you can use Data -
Subtotals,
"At each change in: Month" and "Use function: Count."
--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"Brewisc13" wrote in message
...
We are trying to find out how many birthdays fall with in a given
month
using
excel.