IMPORTRANGE from a separate sheet based on closest date to today's date

by Diane   Last Updated June 10, 2019 17:03 PM

Sheet1 will have data with different past dates

Sheet2 - I want to import data from the 1st sheet and show the data based on today's date.

Related Questions

Query(Importrange) or Query with dates

Updated April 29, 2019 18:03 PM

Adding missing dates to Google Sheets

Updated September 20, 2019 15:03 PM

Using TODAY() function with QUERY

Updated August 25, 2019 06:03 AM