Calculate days between dates and ignore blank cells

[zack8576]

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 SUBMITTED and TURNED IN, while ignoring blank cells
it will then display the average days between dates for each month

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

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Calculate days between dates while ignoring blank cells
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.