1. Home
  2. Computing & Technology
  3. Spreadsheets
Ted French
Ted's Spreadsheets Blog

By Ted French, About.com Guide to Spreadsheets

Excel 2007 DATE Function

Thursday October 29, 2009
Excel has a number of functions available for working with dates and times.

These are known, not surprisingly, as Excel's date and time functions, and they can be found under that heading on the formulas tab of the ribbon in Excel 2007.

One in this group is the DATE function. Unlike the more commonly used NOW and TODAY functions, which can be used to add the current time and/or date to a spreadsheet, the DATE function is often used when dealing with dates or times in formulas or other functions.

As well, it can be used to convert regular dates and times to the computer's serial date.

To find out the details of using this function, read the article on Excel 2007 DATE Function.

Related Articles
Comments

No comments yet. Leave a Comment

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

Explore Spreadsheets
About.com Special Features

Holiday Central

What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets

©2009 About.com, a part of The New York Times Company.

All rights reserved.