I have a tool we use to create travel budgets. Basiclly you enter the departure date into a field and then each day of the itinerary is indexed to get the rate for that day. In another sheet the rates are added and then entered into a budget which calulates the exchange rates, margins, and adds the airfare. Then the final number is the price for the trip. Please see screen shot.
So if I enter a date into BL3, the price will appear in BM2.
I would like to be able to create a table of the price for a range of dates, say 9/1/2018 - 8/30/2019
Currently I manually enter a date into BL3 and record the number that appears in BM2.
Is there a way that excel can create a table of all the possible outputs of BM2 based on a date range that is to be entered in BL2?
Thank you in advance!
So if I enter a date into BL3, the price will appear in BM2.
I would like to be able to create a table of the price for a range of dates, say 9/1/2018 - 8/30/2019
Currently I manually enter a date into BL3 and record the number that appears in BM2.
Is there a way that excel can create a table of all the possible outputs of BM2 based on a date range that is to be entered in BL2?
Thank you in advance!
