I'm using the formula below to total all the sales for 2015 from the beginning of the year through today. It works perfect
=SUMIFS(Table_Query_from_P[HLn Total],Table_Query_from_P[Our Ref Trim],Dashboard!$B42,Table_Query_from_P[CustID],"<>KA",Table_Query_from_P[Year],$C$40,Table_Query_from_P[Ship Date],"<="&TODAY())
For a separate report, I need to modify the formula to not count the days in the current month. Example, today is the 4 day of June. I need the formula to not included these 4 days of June in the total. My report title is "This Year To The End Of May"
Any suggestion?
Bookmarks