I don't know why it wouldn't sort by month. It actually sorts by date, but
that should result month sequence, not alphabetical sequence by month. I
meant to say you should sort your original table before you do the
subtotals. I think you must have anyway.
--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------
"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.