How to find birthdays in Excel using date and related functions
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 or email to send out your ‘Happy Birthday’ greetings.