The Microsoft Offset command is a very powerful function that can help you if you ever need to look at moving averages, or monthly accounts. I personally use this one function with every financial spreadsheet I set up.
This tutorial show you have you can set up a spreadsheet to enter a week number and the number of weeks you want - and the formula will do the rest. It is very powerful stuff and will save you hours and hours if you work with numbers in any way.
|
