Hello, I need to determine the Annual Salary at the time a bonus was given. There's a bonus date and a sal begin and end date. If the bonus date falls between the sal begin and end date then I need the Annual Date reflected in Column E for each EEID. Please see attached example.
There are two sets of data
1) EEID, Date of Bonus and bonus amount
2) EEID, Sal Beg Date, Sal End Date and Annual Salary Amount compensation2.xlsx