Sheet1 will have data with different past dates

Sheet2 - I want to import data from the 1st sheet and find the closest date to today's date.


  • pls share a copy of your sheet
    – user0
    Commented Jun 10, 2019 at 16:13
  • Please add a brief description of your search/research efforts as is suggested on How to Ask. Commented Jun 10, 2019 at 16:47

1 Answer 1


When you want to get data in the same spreadsheet you do not need IMPORTRANGE.
Let's say Sheet1 looks like this:


Then in Sheet2 you need to do this:

=FILTER(Sheet1!A:Z, Sheet1!A:A=MAX(Sheet1!A:A), Sheet1!A:A<=TODAY())


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.