Hello,
I am trying to create a formula for a Pivot table that looks like
this:

Date1 Date 2 Date 3 Etc
Category 1 Total A Total B Total C
Category 2 Total D Total E Total F
Category 3
Etc

=GETPIVOTDATA("Ext Rec Num",B1,"Eff Start
Dt",DATE(2007,3,11))-SUMIF($A:$A,"Category A",C:C)-SUMIF(B:B,"Category
B",C:C)

Any ideas as to why my formula won't continue to reference the Dates
when I drag it across (i.e., to the right)? That is, how can I get
the formula to reference Date 2, instead of continue to reference Date
1, when I try to drag?

Do I need to recreate the formula over and over again?

Thanks for any thoughts!