Financial data usually contains dates; however, date formats are not standard between applications, worksheets, or countries. It is often necessary to make modifications to the date format in order to expedite analysis and adhere to local formatting standards.
In this recipe, you will learn to create an add-in that will allow you to quickly change the date format of a selection of dates within your financial data.
We will begin this recipe by adding code to the Excel worksheet:
Sub DateConvert() ...