How to find birthdays in Excel using
Let's see how we can use date and related functions to find out the
birthdays or marriage anniversaries of friends.
We enter the names and date of birth of our friends as shown. In the
next column we enter today's date using the 'today' function -
'=today()'. In the next column we compare the 'day' and 'month' of the
birthdate and today's date using the 'if' combined with the 'AND',
'=day()' and '=month()' functions. If both the day and month match, we
can display an appropriate message like 'yes' or 'Wish Happy Birthday'.
Now you can use mail-merge to send out your 'Happy Birthday' greetings.