List of acquisition dates

How to get the list of the acquisition dates (Let’s say from 01 Jan 2016 to 01 Jan 2018) for a particular location.

Could you be more specific? If you are referring to Sentinel data, the best option is to check in the Open Access Hub, where you can draw a polygon on you AOI and check for data available by sensor, date and level of processing.
https://scihub.copernicus.eu/dhus/#/home

I could do that by adding all the required products into my cart. I downloaded the cart file(products.meta) and opened with excel and did little processing to get the list of dates in excel.