I have a file that contains dates under column I (start with row 2) and column J (also start with row 2)
I need to build a pivot table to show the number of days between dates in J and I, while ignoring blank cells
it will then display the average days between dates for each month like below

JULY 15 DAYS
JUNE 31 DAYS
JULY 28 DAYS
AUGUST 19 DAYS....etc

below is a data sample
Capture.PNG