Lesson#56: How to make birthday reminder in excel

Here I am having a employee database and I have to make a birthday reminder from it. It needs a little tricks to make it.

I have inserted to columns beside the DOB column, Upcoming Birthdays this Month and Birthday Today

In the Upcoming Birthdays this Month column I have put this formula =IF(AND(MONTH(F2)=MONTH(TODAY()), DAY(F2)>=DAY(TODAY())),F2,”Not This Month”) 

In the Birthday Today column I have put this formula =IF(AND(MONTH(F2)=MONTH(TODAY()), DAY(F2)=DAY(TODAY())),F2,”Not Today”)

Now I have selected both columns Upcoming Birthdays this Month and Birthday Today, right clicked on them Format Cells> Number> Custom
Set the format in dd-mmmm

Now selecting the whole table I have inserted two PivotTables.
One is for Upcoming Birthdays this Month

 

and another is for Birthday Today. 
Arrange the PivotTable Field and Row Labels like I have shown in the picture.

Select both tables right clicked on them Format Cells> Number> Custom
Set the format in dd-mmmm

Now this is the automatic and dynamic birthday reminder.

Download the file. Click Here.

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Tagged with: , , , , , ,

Leave a Reply

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

*