Today's Birthdays

  • Thread starter Thread starter HappyGilmore
  • Start date Start date
H

HappyGilmore

I have a list of 500 students and their birthdays. I would appreciate
a formula that would generate a list each day from the birthdates of
"Today's Birthdays". Little children love to hear their name announced
over the intercom. :)
I thought, wrongly, that I could subtract their birthday from the
current day and divide by 365, but then leap years get in the way.
 
Chip pearson has an Excellent page on Bithdays at:

cpearson.com/excel.htm

Regards
Peter
 
Here's some simple VBA which outputs a MsgBox with all the names. It assumes
the names in column A, birthdays in column B

Dim cRows As Long, i As Long
Dim sNames As String

For i = 1 To Cells(Rows.Count, "A").End(xlUp).Row
If (Month(Cells(i, "B")) = Month(Date) And _
Day(Cells(i, "B").Value) = Day(Date)) Then
sNames = sNames & Cells(i, "A").Value & Chr(13)
End If
Next i

MsgBox sNames
 
Here is another way, you could also highlight the names using conditional
formatting,
With names starting in A2 and birthdays in B2, using David's formula in C2,
=DATE(YEAR(TODAY()),MONTH(B2),DAY(B2)) , select A2 and format, conditional
formatting put formula is =$C2=TODAY() , click on format and pick the
pattern you want and click OK, OK. then select A2 and copy select the other
cells in column A, or A:C if you want them all to have the pattern, then
paste special formats, now the names should be highlighted when it is there
birthday

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
What format is the birthday cell? MM/DD/YYYY ?? My
suggestion is to separate the MM/DD from the YYYY and then
sort the MM/DD column. (Toolbox, data, convert text to
column,and follow rest of instructions.

Hope this helps,

Carole
 
Back
Top