"Excel 2007 Date Function (An example)"


The Excel 2007 Date function allows us to display the current data and time in our worksheet.

The TODAY( ) function automatically retrieves the current date. It is useful for creating spreadsheets that continuously update themselves such as to determines the number of days a payment is overdue.

The NOW( ) function is similar to the TODAY( ) function, except it retrieves the current date along with the current time.


To demonstrate the use of Date and Time Functions: TODAY

  • Create a spreadsheet as follow:
  • Excel 2007 date function worksheet

  • Click on the cell B3, where the answer will appear.
  • From the Formula tab, in the Function Library group, click the Date & Time icon and from the drop down menu, click the TODAY command.
  • Excel 2007 today function

  • From the Function Arguments dialog box displayed, click OK.
  • The today date will display on the cell B3.

Note: If you directly type =TODAY( ) to the cell B3, the same result will appear. The following day, month and year functions are based on this date.


To demonstrate the use of Date and Time Functions: DAY

  • Click on cell B4 and enter the following function:

  • =DAY(B3)

  • Press the Enter key. You will notice that the current day of the month is displayed on the cell B4.


To demonstrate the use of Date and Time Functions: MONTH

  • Click on cell B5 and enter the following function:

  • =MONTH(B3)

  • Press the Enter key. You will notice that the current day of the month is displayed on the cell B5.


To demonstrate the use of Date and Time Functions: YEAR

  • Click on cell B6 and enter the following function:

  • =YEAR(B3)

  • Press the Enter key. You will notice that the current day of the month is displayed on the cell B6.
  • Here are the results:

  • Excel 2007 date function results


The Excel 2007 DATE function is a quick and easy way to insert a date into a formula. DATE( ) accepts three numbers, each of which represents a different component of the date. Here's what it looks like:
DATE(year, month, day)

So, if you enter this formula into a cell:
=DATE(2010, 1, 1)

Excel displays the date 1/1/2010.


Related Topics:

Besides Excel 2007 Date function, you can view the following Excel function tutorials:

How to Write a Formula in Microsoft Excel 2007?
Knowing the Different Types of Excel 2007 Functions
Using Excel 2007 IF Function to Perform the Calculation That Can Ease Your Daily Related Tasks
How to Use the Cell Function in Microsoft Excel 2007?
Guide to Use the NOW Function Correctly in Excel 2007
Use the Microsoft Excel 2007 Product Function to Perform the Calculation
Use the Excel 2007 MAX Function to Find a Largest Number in a Series
Using the Excel 2007 Count Function - Example Demonstration
Guide to Use the Excel 2007 Radian Function Correctly



Can't find what you're looking for? Try Google Search!

Custom Search


Back to Top

You're viewing the Excel 2007 date function info page, click here to go back to the Home Page

Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.