GETPIVOTDATA with cell reference to a date

[Beginner148]

Hi,

I'm trying to use the GETPIVOTDATA function with a date that changes. I have the dates in Row 13 spread across multiple columns.

The formula below works:

=GETPIVOTDATA("Qty",Summary!$B$10,"Transaction Type","RETURN","Invoice Date","2023-10-07")

but if I want to replace "2023-10-07" with the date in cell B13 like below, I get a #REF! error.

=GETPIVOTDATA("Qty",Summary!$B$10,"Transaction Type","RETURN","Invoice Date",B13)

Please can you tell me where I'm going wrong?

 

[jajatidev]

Hi,

I'm trying to use the GETPIVOTDATA function with a date that changes. I have the dates in Row 13 spread across multiple columns.

The formula below works:

=GETPIVOTDATA("Qty",Summary!$B$10,"Transaction Type","RETURN","Invoice Date","2023-10-07")

but if I want to replace "2023-10-07" with the date in cell B13 like below, I get a #REF! error.

=GETPIVOTDATA("Qty",Summary!$B$10,"Transaction Type","RETURN","Invoice Date",B13)

Please can you tell me where I'm going wrong?

View attachment 101606

Hi,
Please align the date format and then give it a try.

 

[jajatidev]

Hi,

I'm trying to use the GETPIVOTDATA function with a date that changes. I have the dates in Row 13 spread across multiple columns.

The formula below works:

=GETPIVOTDATA("Qty",Summary!$B$10,"Transaction Type","RETURN","Invoice Date","2023-10-07")

but if I want to replace "2023-10-07" with the date in cell B13 like below, I get a #REF! error.

=GETPIVOTDATA("Qty",Summary!$B$10,"Transaction Type","RETURN","Invoice Date",B13)

Please can you tell me where I'm going wrong?

View attachment 101606

Please share the data you are working with.

 

[RoryA]

The question was posted 6 months ago; I doubt the OP is still waiting...