Index(Collect) - Need to pull a list of projects done in 2022
I have a datasheet with a list of closed projects in 2022. I need to pull from that sheet only the 2022 closed projects that occurred 12 months ago from today.
I have a helper sheet, that shows 2022 as the year 12 months ago (manually entering that) and the month 12 months ago (also manually entering that).
now need to pull from the datasource only projects occurring in May , 2022
I can't even get it to give me a list of the 2022 projects, need some help please
Range 5 in Sales/Closed is the Project Name
Range 1 is the Year of the Project
Help Article Resources
Check out the Formula Handbook template!