How to Create Birthday Reminder Using MS Excel?

If you don't like the 'ringing'  Birthday Reminder, you can create the silent Birthday Reminder using MS Excel.

 

Here's how to do:

Type as follows

	A	B	C	D
1	NAME	BIRTHDATE	DAY	MONTH
2	BRIAN	01/05/1989	=DAY(B2)=DAY(NOW())	=MONTH(B2)=MONTH(NOW())
3	ERIC	19/06/1990
4	LISA	16/03/1991
5	JEFFRY	19/06/1989
6
7	NAME	BIRTHDATE

 

Description:

In C2: type the formula =your friend's birthdate is equal with current date

In D2: type the formula =your friend's birth month is equal with current month.

 

Data Filter Settings:

1.      Select data range: Click A1 then shift click B5

2.      Click Data menu, Filter, select Advanced Filter

·        Action: Click copy to another location option

·        On Criteria range: click C1, shift click D2

·        On Copy to: click A7 then shift click B7,

3.      Click OK

 

The result is

NAME	BIRTHDATE
ERIC	19/06/1990
JEFFRY	19/06/1989

 

Create a Shortcut Key to easier Run Your Birthday Reminder:

1.  Click Tools menu, Macro, Record a macro

2.  Shortcut key: Ctrl + type  (for example) J

3.  Click OK

4.  Then

· Click Data, Filter, Advanced Filter

· Click copy to another location option

· Click OK

5.  Click Stop Recording button

 

6.  Click File menu, Save : Birthday.xls, press Enter.

 

Run Your Birthday Reminder

1.      Click File menu, Open : Birthday.xls

2.      Press Ctrl+J

3.      And, you will find out which friends have birthdays today.