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))