This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm looking to calculate a 'Week of' or 'Week Ending' date based on the completion dates from a Microsoft Forms survey. The survey is completed on a weekly basis but on different days. I want to group those weekly responses into one 'Week of' or 'Week Ending' category for purposes of summarizing the data.
For example, our most recent survey was completed for the week ending 4/10. People completed the survey over the course of several days ranging from 4/10-4/14.
Our next survey will be for this week ending 4/17, so I want the formula to be dynamic on both a historical and go-forward basis.
You are correct that surveys will always start on Friday (week ending date) and responses are completed before the following week Friday/next week ending date.
What you shared is close and something I might be able to build upon. Unfortunately, there are weeks where we don't always have someone complete the survey on a Friday so there are gaps in the sequence using the Multi-Row Formula tool.