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
    Jun 10 '19 at 16:13
  • Please add a brief description of your search/research efforts as is suggested on How to Ask.
    – Rubén
    Jun 10 '19 at 16:47

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, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.