Hi peeps, I couldn?t find an active ng to ask this question in so t hought I?d ask here:-)
Need a formula to calculate which age range an employee is currently in and display the result in cell c10 ie I have date of birth for an employee in a1 The current date is in b2 If the current age of the employee is under 30, the figure in c4 applies If the current age of the employee is between 30 and 70, the figure in c5 a pplies If the current age of the employee is over 70, the figure in c6 applies
Does anyone know how I can get a formula to do this?
Ta chaps,
Steve