Assignment : using formulas only, complete the table by answering the following question below

Use the table above to answer the following questions by formulating the appropriate formula
(a) Using the first 3 characters of the Surname, Last two Character of the First name, the first 3 characters of the Rank and the day part of the date of birth, generate an employee ID number (Employee ID) for Kubi James in the table. The format of the ID number should look like Opory/Sen/2 which was generated for Opoku Mary
(b) Compute the ages of the employees
(c) If the age of the employee is more than thirty (30) years, the allowance is GH¢200, else the allowance is GH¢150.
(d) If the employee is not more than Sixty (60) years, SSNIT contribution is five (5) percent of the Basic Salary else no contribution.
(e) Net Salary is computed by adding the Basic Salary and the Allowance, and subtracting the SSNIT contribution.
(f) What is the highest age of the employees
(g) Find the average salary of the employees
(h) Count the number of employees
(i) Find the total salary of the employees
(j) What is the lowest basic salary earned in the table
(k) What is the value of the highest paid employee
(l) Compute the number of days Addai David has spent since he was born