Dear all, Can any one post me excel sheet required for making birthday notes in that and also calculate age in the same sheet
From Qatar, Doha
From Qatar, Doha
To keeping birthday reminders:
=IF(MONTH(B4)<>MONTH(TODAY())," ",IF(DAY(B4)<>DAY(TODAY())," ","Happy Birthday"))
Enter birthday date in cell B4 and copy paste this formula in B5. If your DOB and today's date matches then it will show you "Happy Birthday"
Formula to calculate the age:
=INT(Today() - B4)/365.25
Enter DOB in cell B4.
From India, Madras
=IF(MONTH(B4)<>MONTH(TODAY())," ",IF(DAY(B4)<>DAY(TODAY())," ","Happy Birthday"))
Enter birthday date in cell B4 and copy paste this formula in B5. If your DOB and today's date matches then it will show you "Happy Birthday"
Formula to calculate the age:
=INT(Today() - B4)/365.25
Enter DOB in cell B4.
From India, Madras
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.