Birthdate Months

[Alan]

Hi,

Can anyone tell how to resolve this wee problem or, in nice words, where to
go to find help.



I have a group of 'special needs 'using a spreadsheet with a list of their
name and birthday.

It lists their birthday in one cell as: 1/6/46 and the month: June in a
another.



Is it possible to list the total number of students that have birthdays in
say: March or any month throughout the year by clicking or typing in the
month from a range (Jan to Dec)?



I want to type or click a month and it list everyone's birthday for the
Months.

Do I have to create a Macro or can it be done with a formula and, HOW
please?



Many thanks for your help.

 

[Guest]

I would use a pivot table. Put the 'Month' field as your Page. Put the
'Names' field and date filed as the row.

 

[flummi]

Here is another way:

Put the name in A2 and the birthdate in B2.

In C2 enter:
=TEXT(MONTH(B2);"00")&"/"&TEXT(DAY(B2);"00")&"/"&TEXT(YEAR(B2);"0000")

That's for ease of use in the following.

Your months are in D2:O??

In D2 enter: =IF(MONTH($B2)=COLUMN(D)-COLUMN($C:$C);$A2&": "&$C2;"")

Copy the formula to E2:O2 and D2:O2 down as required.

Hans

 

[Guest]

You can use Auto Filter, select one the cells in your list then go to
Data/Filter/AutoFilter and use the Month column as the filter, you could also
insert another column with the day of birth then when the filter is applied
sort the Day column to show which birthday is coming first ( you would need
to do this before using the AutoFilter).

HTH
JG

 

[Alan]

Hey Guys n' Gals
Many thanks for your help. Will probably try them all just for the
experience.
Been using a 'Filter' which, as you know, groups the their name and all
birthdays in that month.
Many thanks