Forum Discussion
Amy_Sljivar
Dec 06, 2023Copper Contributor
Excel - Pull information from one sheet to another based on a date value
Hello, I hope I can word this correctly. I would like to import data from one sheet to another based on a date value within 30 days of today. Basically I have a contacts spreadsheet with a list of s...
HansVogelaar
Dec 06, 2023MVP
Let's say that the first sheet is named Contact Sheet, with data in A2:W1000, and renewal dates in D2:D1000.
On another sheet, enter the following formula in a cell:
=FILTER('Contact Sheet'!A2:W1000, 'Contact Sheet'!D2:D1000<=TODAY()+30, "")