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
1=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
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Employee excel sheet.xls