This is awesome. Thank you, Roy!
Also, if you don't mind how can I see which day (Mon-Sun )and month generated the most number of orders from 2018/2019?
Thank you so much for your help.
May I ask what formula did you use to calculate the number of orders per 7 days?
Thanks for your prompt response. Attaching my workbook for reference.
I hope you are all well and safe. Anyone who can help me out in creating a graph in excel that will show how many orders were created in a 7 day rolling period? What formula can I use?
I only have 2 columns on my excel sheet.
Column A - Date order is created
Column B - Number of orders made per day
Any help would be much appreciated.