3 Replies Latest reply: Dec 2, 2011 4:08 PM by Kristy McGee RSS

    Sum if Date1=Date2+1

      Good afternoon,

       

      I have two spreadsheets.  One shows when we have called customers and the other one is the results of the call.  We have a call center and one sheet is where i get the call date and the account number.  the second spreadsheet shows when the date that person promised to pay and when they actually did pay. 

       

      I need to build a chart that shows when we have called a person and they paid the same day, the next day, third day...on to 7 days from the date called.  This sounds straightforward but I built a pivot table that shows.

      //total promised

      sum(PromisetoPayamount)---WORKS

       

      //same day

      sum(if(CallDate=PTPDate, PTPAmount))--WORKS

       

      //next day

      sum(if(CallDate+1=PTPDate, PTPAmount)) -- Does not work

       

       

      As always any assistance would be greatly appreciated.