Forum Discussion

Amy_Sljivar's avatar
Amy_Sljivar
Copper Contributor
Dec 06, 2023

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 suppliers and their contract renewal date. I would like to have another sheet within the document that only displays Contracts that are within 30 days of their expiry date. But I would need all the cells from that Row to pull through. Hope that makes sense and thankful for any advise received 🙂

1 Reply

  • Amy_Sljivar 

    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, "")

Resources