date format changed in pivot

Hi,

I have tab where i have got start and nd dates. dat are i format dd/mm/yyyy. it was pikin them up i the right format but now fr the end date it gives 00/01/1900.
e.g

start date end date
01/01/216 1/06/2017

In pivot, I a getng 01/01/2016 as start date which is fine but end date is coming out as 00/1/1900. what i gettin wrong here?

I hv checked the format and its all fine so wud be great if someon ou help me here

thanks fr your help in advance
regards,
FH

would be great if someone could help me out here

Hi,
it would be better if you can share a sample of your workbook to understand your issue.