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!

On Feb 11, 3:03*pm, Mike C wrote:
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.