Hello everybody,

I have a spreadsheet in Excel 16, with monthly mutual funds' returns. The column of the dates shows the date as the last day of the month taken into account. Data go from January 2013 to December 2019.
When I import the spreadsheet to STATA 16, it reads the dates as daily and shows that there are gaps. How can I convert the dates into monthly dates in STATA?

Thank you very much for your help