1

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.

https://docs.google.com/spreadsheets/d/1Kr5NRb4TmNhr8hQb2DXt6pdK4UC3H1IUFGjvQtucWQw/edit?usp=sharing

2

1 Answer 1

0

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

0

Then in Sheet2 you need to do this:

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

0

Your Answer

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