I have a formula in spreadsheet to pull data from a pivot table. Part of the
formula is a Date function. I would like to copy this formula down the
spreadsheet with the date advancing to the next day, but it only directly
copies the fomula. How can I get this to work without going into each cell
and changeing the date?

=GETPIVOTDATA("Result",Pivot!$A$4,"Result","In","L ocation","Finished
Product","Line",11,"Sample type2","0 day","MFG",DATE(2010,1,1))

Hi Kathy

Maybe
=GETPIVOTDATA("Result",Pivot!$A$4,"Result","In","L ocation","Finished
Product","Line",11,"Sample type2","0 day","MFG",DATE(2010,1,ROWS($1:1)))


--
Regards
Roger Govier

wrote:
I have a formula in spreadsheet to pull data from a pivot table. Part of the
formula is a Date function. I would like to copy this formula down the
spreadsheet with the date advancing to the next day, but it only directly
copies the fomula. How can I get this to work without going into each cell
and changeing the date?

=GETPIVOTDATA("Result",Pivot!$A$4,"Result","In","L ocation","Finished
Product","Line",11,"Sample type2","0 day","MFG",DATE(2010,1,1))

Hi Kathy

Maybe
=GETPIVOTDATA("Result",Pivot!$A$4,"Result","In","L ocation","Finished
Product","Line",11,"Sample type2","0 day","MFG",DATE(2010,1,ROWS($1:1)))

--
Regards
Roger Govier

wrote:
I have a formula in spreadsheet to pull data from a pivot table. Part of the
formula is a Date function. I would like to copy this formula down the
spreadsheet with the date advancing to the next day, but it only directly
copies the fomula. How can I get this to work without going into each cell
and changeing the date?

=GETPIVOTDATA("Result",Pivot!$A$4,"Result","In","L ocation","Finished
Product","Line",11,"Sample type2","0 day","MFG",DATE(2010,1,1))

Use a cheater row.
Assuming your formula is in Column G, put your dates in column H.
Now change the formula to something like this...
=GETPIVOTDATA("Result",Pivot!$A$4,"Result","In","L ocation","Finished
Product","Line",11,"Sample type2","0 day","MFG",H4)

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



" wrote:

I have a formula in spreadsheet to pull data from a pivot table. Part of the
formula is a Date function. I would like to copy this formula down the
spreadsheet with the date advancing to the next day, but it only directly
copies the fomula. How can I get this to work without going into each cell
and changeing the date?

=GETPIVOTDATA("Result",Pivot!$A$4,"Result","In","L ocation","Finished
Product","Line",11,"Sample type2","0 day","MFG",DATE(2010,1,1))

Hi Kathy

Maybe
=GETPIVOTDATA("Result",Pivot!$A$4,"Result","In","L ocation","Finished
Product","Line",11,"Sample type2","0 day","MFG",DATE(2010,1,ROWS($1:1)))


--
Regards
Roger Govier

wrote:
I have a formula in spreadsheet to pull data from a pivot table. Part of the
formula is a Date function. I would like to copy this formula down the
spreadsheet with the date advancing to the next day, but it only directly
copies the fomula. How can I get this to work without going into each cell
and changeing the date?

=GETPIVOTDATA("Result",Pivot!$A$4,"Result","In","L ocation","Finished
Product","Line",11,"Sample type2","0 day","MFG",DATE(2010,1,1))