Return the value shown in based on a date range

I have been struggling with how to return a value stated in a particular cell when determining the date range between two dates.

A2 has the arrival date, B2 has the departure date, C2 indicates the number of days between those dates.

I need to return the correct value in A5 (Dollar Value) and days that are indicated in C2
to show in B5 based on the dates inputted in A2 & B2.

I am using the date range of 3 rows. The first column of the row is the arrival date the second; departure date and third is the dollar value or rate to be applied to A5.

Attached is the excel sheet.

Book1 - Copy.xlsx

Help is much appreciated.

See the attached

thanks so much, that really help. I noticed that the B5 returns a higher value than stated in C2. Can I simply change that by doing a paste link of C2 to B5?

Thanks