GETPIVOTDATA Date Return|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi,

I have two pivot tables, they both contain some matching data.  I'm trying to use the GETPIVOTDATA formula to pull through a date from one of the pivots to a cell adjacent to the other.  If you see on the attached sample, I'm trying to get the "Contract from" and "Contract to" date from the pivot on the "Contract Length" sheet to appear adjacent the corresponding record on the "Contract Payments" sheet.  

So, in cell K3 on the Contracts payment sheet, the data should read: 1/4/19; L3 would be: 31/03/21.

The sheets I want to use the formula on are a lot bigger so it's impractical to do it manually.

I'm on a PC using Excel 2016 

Thanks for your help

Special K