I am working on a daily sales report that sets a sales goal for the current month based on the total sales of the past six months. So for this month (August) I need to see the total sales from 2/1/2015 through 7/31/2015 to calculate the new goal for the month. I need that range to change as the months go by,
Right now my formula looks like this month(currentdate)-6 would give me the start of the range by returning a 2 for February. However, if the current month was March the same formula returns -3 instead of 10 for October (previous year).
I'm also not sure how to get the end of the range (last day of previous month).