Hello,
I have a complex worksheet that I need to extract data from that meets certain conditions. I've attached the spreadsheet.
I would like the formula to tell me all the document numbers with planned dates within 30 days of the current date. If they results can be sorted by process or gate set as well, that would be awesome.
For example: Today's date of December 1. Anything with a planned date being within December would be listed by the corresponding Doc. No listed in column "E".
thanks in advance. I can help clarify if there are any questions.
Bookmarks