Interesting Use of Date Function in Excxel

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.

Further reading:
TODAY function

Leave a Reply

Your email address will not be published. Required fields are marked *