6 Tricks to Make Dates Work in Excel

Add to Favorites
Author: | Edits: don

Watch this tutorial if you work with dates!

Quick and easy ways to reliably convert dates from plain text or numbers or simply the wrong format into working dates in Excel.

6 ways to make almost any date in Excel work like a regular date, where you can run formulas and functions against it and perform calculations on it.

This includes 5 helpful methods to transform most dates and 1 trick to make almost any kind of date that a user can enter into Excel into a properly formatted date.


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
Vlookup on Dates and Times in Excel
Tutorial: Perform a lookup on dates and times in Excel: vlookup, hlookup, index/match, any kind of l...
How to Use Dates in Excel
Tutorial: Introduction Guide to using Dates in Excel - this tutorial will show you how to input and...
Allow Only Certain People to Edit Specific Cells in Excel
Tutorial: How to allow only certain people to edit certain cells or ranges in Excel. This is a sec...
Logical Comparison Operators in Excel - How to Compare Things
Tutorial: (Video tutorial's page: Compare Values in Excel - Beginner to Advanced) Logical compariso...
Make Professional Looking Rounded Buttons in Excel
Tutorial: How to make professional looking rounded buttons in Excel. This allows you to avoid using ...
Excel Formula Formatting Trick to Make Life Easier
Tutorial: This Excel Quickie WILL make your life much easier with long formulas, even if you are al...