Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
2003 teachers & student edition
When making out an invoice I need a formula to change the date automatic to
the correct date. Thanks for the help, |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
2003 teachers & student edition
What is meant by "correct date"? Today? =TODAY() will return the current
date, but it will update with every calculation, so if you open the workbook tormorrow, you'll tomorrows date. If you want enter today's date in an un-update mode, use CTRL+<semicolon. Beyond that, there's little to say without knowing what you mean by "correct date". -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Bruce" wrote in message ... When making out an invoice I need a formula to change the date automatic to the correct date. Thanks for the help, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why can't I use XML in the Student and Teacher Edition? | Setting up and Configuration of Excel | |||
How do I open a Quattro Pro 7.0 file in Excel 2003 | Excel Discussion (Misc queries) | |||
update row numbers after different active cells in macros followi. | Excel Discussion (Misc queries) | |||
New web query with Excel Pro Edition 2003 | Links and Linking in Excel | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |