Avatar of Audra Breedlove
Audra Breedlove

asked on 

Determine value if a date is with two date

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
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Rob Henson

8/22/2022 - Mon