Hello All,
See attached. Book4.xlsx
I am trying to compute a formula that will look total up the Amount in Column B for the previous month and list what the difference is in the month previous to it.
Example
Today is 3/11/2015. I need a formula that will compare the previous month (Feb) to the month prior to it (Jan) and show what the difference is in $$. However, on April 1, 2015, this formula should compare March to Feb.
Does that make sense?
Bookmarks