Formula to apply number based on date range?

[Cdyerbg]

Hi

I am looking to get a formula based on my spreadsheet attached

I want F collumn to add 5 days onto whatever date you put in there then correspond it to the matched date period in I2-I6 then apply the pay period from H2-H6 and put it in the G Collumn next to the date that has been input?

Is this possible?


help.jpg
Book1.xlsx

[Pepe Le Mokko]

Title adapted - Thx