calculate age from 1st of current month
I am writing a fast formula which requires that I know the age of the employee as at the 1st of the month that I am running for. Using PER-AGE gives me the age of the employee as at the run date. I need this to be extremely accurate as I need to allow benefits for employees who are 64 on first of the month even if they turn 65 during the month.
All help gladly appreciated.
Thank you
Jill