Here’s a fun trick to try with Excel. You can make a list of friends or colleagues and create a birthday reminder. Here’s how to do it.
First, you’ll need to create a worksheet and input the names and birthdates of friends or colleagues. Use any date format you prefer.
Next, enter or copy this formula into the cell:
=IF(MONTH(C3)<>MONTH(TODAY()),” “,IF(DAY(C3)<>DAY(TODAY()),” “,”Happy Birthday”))
C3 is the cell which contains the birthday date, you can change it as you need) into a blank cell D3, for example.
Press the Enter key, then select the cell D3 and drag the fill the handle to the range where you want to apply this formula. When the birthday date arrives it will show a message Happy Birthday in the cell. An Example: If the date is October 8 today, it will show Happy Birthday to Ritika.
~ Jiten Chaturvedi