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

By Ted French, About.com Guide to Spreadsheets

Excel 2007 NOW Function

Tuesday October 27, 2009
Excel has a number of functions available of adding the date and time to a spreadsheet.

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 of the more commonly used in this group is the NOW function, which adds the current time and date to a cell in your spreadsheet.

You can then format this entry to show just the current date, or just the current time, or leave it as is if you want both displayed.

To find out the details of using this function, read the article on using the Excel 2007 NOW 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.