Index/Match formula based on date range?
Hi. I am looking at setting up a formula to reference another sheet's key accomplishments and major upcoming activities column based on a date. Right now it's set up to where we populate the original sheet by the Friday of each week. I've played around with getting the index formula to work but am struggling to build the date logic. Any suggestions? It would need to look for this week's Friday date and populate the key accomplishments and upcoming activities based on a specific workstream name week over week
Help Article Resources
Check out the Formula Handbook template!