I have a spreadsheet, using google sheets, that I have formed into the following metrics:
Column A is the dates of the month
Column B is the data
I want to be able to copy the data from Column B into Column D Cell 1 based on today's date and have Column D Cell 1 update every day based on the day of the month it is.
Today's date 6/6/2018
Data is pulled from Column B using the defined date of today, and posted into D:1, and each new day the column is automatically updated.
Any help is appreciated.