It sorts by Year.

"Dave Peterson" wrote:

Another option...

Use a helper cell with this formula:

=text(a1,"mmyyyy")

And fill down.

brewisc13 wrote:

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.




--

Dave Peterson