Need to find formula to say happy birthday [Closed]

Report
Posts
1
Registration date
Friday April 9, 2010
Status
Member
Last seen
April 9, 2010
-
rizvisa1
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
-


i would like to say happy birthday to each of my employees on there spreadsheets in excel 2007. I am having a hard time to get each of there birthdays to work , I can get it to work for today's date, but I need there birth dates to work as the day comes up. any help with the formula would be a great help.

Thank you

2 replies

Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
756
more information is needed
Posts
1023
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
242
what you would need is a cell with the particular birthday in question as a reference point, Then using a formula link it to another cell. This cell would be todays date. when the birth date cell and todays date cell match, then voila happy birthday.

could you provide an example of your spreadsheet so we can elaborate on what I have suggested.
can you help with the formula.
rizvisa1
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
756
newbie, you need to give more information