Need an Excel Template for Birthday Notes with Automatic Age Calculation?

mushab
Could anyone please share an Excel sheet template required for creating birthday notes? Additionally, I would like the sheet to calculate the age automatically. Thank you.

Regards
rpdharani
Birthday Reminder Formula

To keep birthday reminders:

=IF(MONTH(B4)<>MONTH(TODAY())," ","IF(DAY(B4)<>DAY(TODAY())," ","Happy Birthday"))

Enter the birthday date in cell B4 and copy-paste this formula in B5. If your date of birth (DOB) and today's date match, it will display "Happy Birthday."

Formula to Calculate Age

=INT((TODAY() - B4)/365.25)

Enter the DOB in cell B4.
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute