I'm looking for a formula that will do this.
Sum all expense from 2011 through a specified date.
The end of the specified date I need to be able to divide by 12 then multiple by X months
So:
2011 through 2015 but expense reflected a sum of 2011 through 6 months into 2015.
Easy right? HUH!
Sum all expense from 2011 through a specified date.
The end of the specified date I need to be able to divide by 12 then multiple by X months
So:
2011 through 2015 but expense reflected a sum of 2011 through 6 months into 2015.
Easy right? HUH!