Dragging the GETPIVOTDATA formula across and change dates automatically

user_10419493 0
Viewed 162

I need help with the below GETPIVOTDATA formula.

My formula is as follows:

=GETPIVOTDATA("Invalid (Percentage)",'Validity'!$A$11,"Submit Date",DATE(2018,10,1),"SITE","London","Is it valid?"," ")

Each time when I drag this formula across, date remains the same and I have to manually amend my formula to DATE(2018,10,2) if I would like to see results for the 2nd October.

As I have multiple tables and pivot tables in my report, I would like to link this formula with the above dates in my table so that each time when I drag my formula across, the date in my formula will be also automatically amended and the correct results displayed for the specific day.

My table looks as follows:

enter image description here

Thanks in advance.

pivot-table excel-formula excel
1 Answers

If say starting in ColumnH, maybe adjust DATE() to:

=DATE(2018,10,1+COLUMN()-8)
user_15051200
Related