1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel Date Options

Sort by Date, Formatting the Date and More

By

The Date is an important part of most Excel spreadsheets. Beyond just adding the current date, you may find it useful to sort data by date, find data that was added before or after a certain date, or format the date in a variety of ways. Each tutorial listed below includes a step by step example of working with dates in Excel.

Sort by Date in Excel

Excel Date Tutorials
Excel Date Tutorials

In addition to sorting regular data in a spreadsheet, such as numbers or names, Excel's sort feature can also be used to sort by date. This tutorial includes a step by step example of how to sort by date in Excel.

Excel Conditional Formatting for Dates

Excel Date Tutorials
Excel Date Tutorials
Adding conditional formatting to a cell in Excel allows you to apply different formatting options, such as color, to a cell or cells that contain dates. Doing so allows a date that has past - such as overdue bills to be easily spotted. Similarly, a date in the future can also be highlighted using different background and/or font colors.

Add the Current Date in Excel with a Keyboard Shortcut

Excel Date Tutorials
Excel Date Tutorials
This tutorial shows you how to add the current date to an Excel spreadsheet using a keyboard shortcut. This method does not use a function such as the TODAY function to add the date to the spreadsheet.

Formatting the Date using a Keyboard Shortcut

Excel Date Tutorials
Excel Date Tutorials
This tutorial shows you how to format the date (day, month, year format) in an Excel spreadsheet using a keyboard shortcut.

On What Day Was I Born?

Excel Date Tutorials
Excel Date Tutorials
Excel is normally used for serious business type work. It can, however, also be used for less serious, but equally important tasks such as finding out what day of the week you were born on.

©2014 About.com. All rights reserved.