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.
Bookmarks