I'm trying to work out a price sheet for some equipment I'm buying. I would like to have a cell change it's date based on today's date that's in columns so it can show me today's date as a quick reference and to fill in another cell on a different page to compare prices between purchase locations. Just can't figure out the formula for B3:B7 to get what I want.Example is pictured.
Changing cell based on date in another cell
google spreadsheets