Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Bruce
 
Posts: n/a
Default How do I set date to change automatic when making an invoice

I am using Office 2003 students & teachers edition. I would like to set up
the invoice so the date will change to the correct date when the invoice is
opened. Thanks, Bruce
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Is the correct date today's date?

If yes, you could use
=today()
in that cell.

Be aware that if you leave that formula in the cell, then that date is not
static. It'll change whenever the date changes.

Bruce wrote:

I am using Office 2003 students & teachers edition. I would like to set up
the invoice so the date will change to the correct date when the invoice is
opened. Thanks, Bruce


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Turn off automatic date formatting? Nick Turner Excel Discussion (Misc queries) 3 July 13th 06 08:13 AM
Formula to change number into date anjgoss Excel Discussion (Misc queries) 4 September 28th 05 10:47 AM
How change Excel default date format to something useful mjk Excel Discussion (Misc queries) 1 September 26th 05 08:15 PM
Automatic Populate Todays Date in Cell when File is Saved. Nello Excel Discussion (Misc queries) 3 April 21st 05 11:08 PM
How do I set date to change automatically on invoices created wit. Angel New Users to Excel 3 November 30th 04 04:10 AM


All times are GMT +1. The time now is 11:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"