To ensure only authorized people access the data you need to set up worksheet permissions. You can use the same formula to calculate the number of years a certain employee has been working in your entity.Īll you need to do is enter the the formula on the first cell then drag down Step 3: Set permissions on the Employee DatabaseĮmployee database should be secured.
=(YEAR(NOW())-YEAR(B2))Ĭhange B2 to the cell containing the Employees Date of birth then drag the formula down to apply it to the rest of the cells. To achieve this use the following formula. Excel formula can calculate the employees age based on their date of birth. Keeping track of age manually can be very tiresome. One of the the most prevalent data in most employee data bases is age. To make your database easy to work with and efficient you need to leverage on Excel formulas. Start by filling names then followed by their details such as date of birth, age, and salary Step 2: Use =(YEAR(NOW())-YEAR(DOB)) to calculate the Age of employees automatically You can save it with a unique name to differentiate it from other files.Ģ: Fill the Employee data on the spreadsheet. You can add fill to make it stand out from the rest of the cells.Ĭlick on file then save the excel file.
