Hi all,
I am trying to get the MTD and run-rates figures by using a normal sum function and then re-adjusting the formulas.
For MTD, i use the sum function from the 1st of the month to yesterday's date.
The run rates compare the sum of the last 7 days with the sum of the same days 4 weeks prior.
Is there an easier way how to do obtain the figures? Should I use the OFFSET function, and if so, how?
Thanks
Bookmarks