Prev: Formatting Phone Numbers in Excel 2007 Help
Next: Tabs Names
From: Roger Govier on 30 Mar 2010 17:35
Hi Kathy

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


--
Regards
Roger Govier

kathy.pinkerton(a)waters.nestle.com 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","Location","Finished
> Product","Line",11,"Sample type2","0 day","MFG",DATE(2010,1,1))
First  |  Prev  | 
Pages: 1 2
Prev: Formatting Phone Numbers in Excel 2007 Help
Next: Tabs Names