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

Excel Date Functions - Adding the Date to a Spreadsheet

Functions That Will Add a Date in Excel

By

The functions listed below can be used to add the current date to an Excel spreadsheet. Each tutorial includes step by step examples of working with dates in Excel.

Adding the Current Date in Excel Using Short Cut Keys

Excel Date Function Tutorials
Excel Date Function Tutorials
Quickly add the current date to Excel using shortcut keys on the keyboard. In addition to being fast, when the date is added this way it does not change every time the worksheet is opened like it does with some of Excel's date functions.

Excel NOW Function

Excel Date Function Tutorials
Excel Date Function Tutorials

The NOW function will add both the current time and date to a spreadsheet. You can choose to format the function to show either the current time or date or both. This tutorial includes an example of using the NOW function in Excel.

Excel TODAY Function

Excel Date Function Tutorials
Excel Date Function Tutorials

The TODAY function adds the current date to a spreadsheet in the default format. You can use the various date format options to change the appearance of the date. This tutorial includes an example of using the TODAY function in Excel.

Excel DATE Function

Excel Date Function Tutorials
Excel Date Function Tutorials

The DATE function can be used to add a date to a spreadsheet. The date added does not have to be the current date. It can also be used to ensure that when dates are added to a spreadsheet they are formatted as text which prevents them from being used in formulas and other functions. This tutorial includes an example of using the DATE function in Excel.

©2014 About.com. All rights reserved.