Easy Date Conversion with VBA

Add to Favorites
Author: | Edits: don

VBA to easily convert dates seen as text into formatted date types in Excel, especially when going between USA & World Date formats.

This issue is a real problem when importing Text or CSV files into Excel, especially if your system uses non-USA formats for dates or you are working with data sets that have mixed date formats.

This tutorial shares a small piece of VBA that will help you to convert your dates into the correct format in Excel, whichever format that is for you.


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Get Formulas from Cells in Excel with VBA
Tutorial: Get a formula from a cell using VBA in Excel. This method returns the actual formula inste...
Select Ranges of Cells in Excel using Macros and VBA
Tutorial: This Excel VBA tutorial focuses specifically on selecting ranges of cells in Excel.  This...
Guide to Creating Charts with a Macro in Excel
Tutorial: How to add, edit, and position charts in Excel using VBA. This tutorial covers what to do ...
Find the Next Blank Row with VBA Macros in Excel
Tutorial: Learn how to find the next empty cell in a range in Excel using VBA and Macros.  This me...
Join a Date and Time into a Single Cell using VBA Macros in Excel
Tutorial: In order to combine a cell that has a date with a cell that has a time, using a Macro and ...
Countdown Timer in Excel
Tutorial: How to create a countdown timer in Excel. This allows you to display a timer in whatever ...
Tutorial Details
Downloadable Files: Excel File
Similar Content
Get Formulas from Cells in Excel with VBA
Tutorial: Get a formula from a cell using VBA in Excel. This method returns the actual formula inste...
Select Ranges of Cells in Excel using Macros and VBA
Tutorial: This Excel VBA tutorial focuses specifically on selecting ranges of cells in Excel.  This...
Guide to Creating Charts with a Macro in Excel
Tutorial: How to add, edit, and position charts in Excel using VBA. This tutorial covers what to do ...
Excel Forum