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.

Question? Ask it in our Excel Forum


Downloadable Files: Excel File

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...
Logical Comparison Operators in Excel - How to Compare Things
Tutorial: Logical comparison operators allow you to compare values in Excel to see if they are equal...
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...
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...