• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

6. Hacking Formulas and Functions > 65. Convert Dates to Excel Formatted Dates

Convert Dates to Excel Formatted Dates

Dates imported from other programs frequently cause problems in Excel. Many people manually retype them, but there are easier ways to solve the problem.

Let’s look at some of the date formats you might encounter and how to convert them to standard Excel dates.

As Figure 6-6 shows, the formulas in column B convert the data in column A to three results in column C, all of which follow the U.S. date format of mm/dd/yy.

Date formats converted to valid dates (U.S. format)
Figure 6-6. Date formats converted to valid dates (U.S. format)

Figure 6-7 shows the same approach at work, except that the cells in column C were formatted with the European date format of dd/mm/yy.

Date formats converted to valid dates (European format)
Figure 6-7. Date formats converted to valid dates (European format)

PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint