How to Auto-Format the Date in MS Excel. When you create Microsoft Excel spreadsheets that contain one or more columns of dates, you can make things a bit easier if you pre-format your cells to ...

If you need a monthly or yearly balance for revenue transactions in Microsoft Excel, you're in luck because both are easy! Here's how to find the totals you need.

Microsoft Excel handles dates as numbers, even though they display as dates -- for example, the date "10/10/2011" is really stored as "40826." This makes it difficult to directly add or subtract ...

If you have to work with a date stamp in Microsoft Excel that includes date and time, you can use these simple expressions to extract both components, making them easier to work with.

You can sort data by dates in Microsoft Excel and Excel Online. Learn how to sort all the columns according to date column using this tutorial.