will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.
Entering Dates and Times in Excel
Posted on November 20th, 2008 by Debra Dalgleish
In yesterday’s post I showed formulas you can use to pull information from a date in Excel. In some workbooks you’ll enter dates manually, but often you’d like a date to be calculated automatically.
Calculate the Current Date
To show the current date in a cell, use the TODAY function:
=TODAY()
This date will update automatically when you [...]
Filed under: Excel, Programming, VBA | 2 Comments »
