2 Replies Latest reply on Feb 20, 2012 5:51 PM by Bruno Vais

    How to calculate week to week difference

    Bruno Vais

      Hi,

      I have a bar chart that connects to a spreadsheet that looks like this. The bar chart displays the counts for the previous week.

      I need to display in the caption the previous week total (02.12 to 02.19) and the total for the week before (02.06 to 02.11).

      Is there any way to do that? (workbook and spreadsheet attached).

       

      tnx

       

      DateCount
      2/6/121
      2/7/122
      2/8/123
      2/9/124
      2/10/125
      2/11/126
      2/12/127
      2/13/128
      2/14/129
      2/15/1210
      2/16/1211
      2/17/1212
      2/18/1213
      2/19/1214