How to Record Data Weekly
I now have 1 main sheet, and then 4 different sheets where it moves over data to, 4 times throughout the month, using automation to move certain rows by month on the I.e. 7th etc. then I have a dashboard showing the different data of the 4 sheets, so you see 4 times throughout the month how the numbers changed.
Is there any way to record the data weekly?
so I'll have last week Friday, 2 weeks 3 weeks and 4 weeks ago Friday,
Thank you! 😀
Help Article Resources
Check out the Formula Handbook template!