GetPivotData - Why does the reference not change when I drag theformula?

[Mike C]

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!

 

[Mike C]

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!

Ok, I think I figured it out. I simply needed to reference the cell
and not the date.