Update Daily Exchange Rate to a spreadsheet everyday to a new date

I have a spreadsheet that updates the daily exchange rate to a given cell. I have a column of dates that I wish to have that given date equal that day's rate without changing the previous date's rate...