How to Make calculation in Pivot table

[arpitjoshi]

Last date of the month should be subtracted from max date of data.

Note- Only 7 day data will show in pivot table .

please see i have attached  demo of final result excel screnshot .