Hi All,
i am trying to work out the difference of sales between current week and the week prior.
my formula so far is:
=COUNTIFS(Historical!C:C,B2,Historical!$A:$A,A2,Historical!$I:$I,WEEKNUM(TODAY())-1)
im struggling to work out how to compare it to the current week.
any help will be...