sum automatically from last 12 months based on current date
I have a database consisting of monthly hours covering the last 10 years.
Occassionally, I need to sum up the hours from the last 12 months. Which
Excel function do I use so that a cell will automatically show the sum of
hours from the last 12 months based on the current date?
|