=text(a1,"mmyyyy")

Sorts by years.

I see 062005 in that cell if A1 contains today's date.

I used the mnemonics for USA/English for month and year. If you're not using an
English version of excel, you'll have to use your language's abbreviations.

If you're not sure, post what language you're using.

brewisc13 wrote:

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


--

Dave Peterson