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