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
Acknowledge(0)
Amend(0)
From Qatar, Doha
Acknowledge(0)Amend(0)
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 the age:
=INT(TODAY() - B4)/365.25
Enter the DOB in cell B4.
From India, Madras
Acknowledge(1)Amend(0)
1=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 the age:
=INT(TODAY() - B4)/365.25
Enter the DOB in cell B4.
From India, Madras
Acknowledge(1)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
SALARY SHEET CALCULATION.xls