Calculate the numbers months for probationary staff in a year whereby before an employee is closer to the month of confirmation the excel sheet will give a signal with a specific color.
From Nigeria, Lagos
Acknowledge(0)
Amend(0)
From Nigeria, Lagos
Acknowledge(0)Amend(0)
In Nigeria, the standard probation period for employees is typically 3 to 6 months, but this can vary depending on the company's policy. Here's a step-by-step guide on how to set up an Excel sheet to track the probation period of your employees and set a visual alert before the confirmation month.
1. 🤡 Open a new Excel spreadsheet.
2. 🤵 In the first row, create the following headers: "Employee Name", "Hire Date", "Probation End Date", "Months Remaining".
3. 🤪 Enter the respective data for each employee in the appropriate columns.
4. 🤡 In the "Probation End Date" column, use the Excel date function to calculate the end date of the probation period. Simply add the duration of your standard probation period to the hire date.
5. 🤖 In the "Months Remaining" column, use the Excel DATEDIF function to calculate the number of months remaining in the employee's probation period.
6. 🤰 To set up a color alert, use conditional formatting. Highlight the "Months Remaining" column, go to Home > Conditional Formatting > New Rule.
7. 🤍 In the New Formatting Rule dialogue box, select "Format cells that are LESS THAN" and type in the number of months before confirmation that you want to be alerted. Then, click on the Format button and choose the color you want for the alert.
8. ✔️✅ Click OK.
Now, when an employee is approaching their confirmation month, the cell will change color to alert you.
Remember, always ensure that all employment practices, including probationary periods, are in line with the Nigeria Labour Act and your company's policies.
From India, Gurugram
Acknowledge(0)Amend(0)
731. 🤡 Open a new Excel spreadsheet.
2. 🤵 In the first row, create the following headers: "Employee Name", "Hire Date", "Probation End Date", "Months Remaining".
3. 🤪 Enter the respective data for each employee in the appropriate columns.
4. 🤡 In the "Probation End Date" column, use the Excel date function to calculate the end date of the probation period. Simply add the duration of your standard probation period to the hire date.
5. 🤖 In the "Months Remaining" column, use the Excel DATEDIF function to calculate the number of months remaining in the employee's probation period.
6. 🤰 To set up a color alert, use conditional formatting. Highlight the "Months Remaining" column, go to Home > Conditional Formatting > New Rule.
7. 🤍 In the New Formatting Rule dialogue box, select "Format cells that are LESS THAN" and type in the number of months before confirmation that you want to be alerted. Then, click on the Format button and choose the color you want for the alert.
8. ✔️✅ Click OK.
Now, when an employee is approaching their confirmation month, the cell will change color to alert you.
Remember, always ensure that all employment practices, including probationary periods, are in line with the Nigeria Labour Act and your company's policies.
From India, Gurugram
Acknowledge(0)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.
Appointment Letter to an Employee for fixed period.doc
Employee excel sheet.xls