Pivot setting for auto calculate remaining days from the data

**siddiq1212** · 02-19-2020, 09:00 AM

Hi,
Dear expert's is there any way to calculte no of days remaining for each cell from a range.
I want pivot to calculate no of remaining days from each columns.
Finish
A 5-Mar
B 20-Jun
C 15-Sep
D 21-Oct

**Pepe Le Mokko** · 02-19-2020, 09:02 AM

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

**siddiq1212** · 02-19-2020, 11:20 AM

Thanks for the Guidance,I want to add a column in sheet 2 after each entry which should calculate remaining days after each column A, B ,C ,D etc.
Don't want to disturb data sheet.

Thanks

**rondeondon** · 02-23-2020, 10:51 PM

Can you please elaborate on the desired outcome? how do you define "Remaining days" where do you want it to show? what do you want to achieve? Can you add to the attachment what you'd like to see as an end result to work towards?