"Create Date"

October 26, 2011 at 06:46:32
Specs: Windows XP
In Excel 2003 is there a "Create Date" function? I used Today() but of course that date would change every time the spreadsheet is opened. I want the date to be displayed that was the date that the spreadsheet was created.

See More: "Create Date"

October 26, 2011 at 07:28:43
I'm a tad confused.

If you have tried the TODAY(), that tells me that you are willing to enter something in a cell when the workbook is first created. If that's the case, why not just enter the date?

If you don't want to think about what date it is, try this:

To enter the current date, press Ctrl + ; (hold the Ctrl key while typing a semicolon.)
To enter the current time, press Ctrl + : (hold the Ctrl key while typing a colon.)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

October 26, 2011 at 07:40:56
I created the spreadsheet for doing quotes for our sales department. I wanted to make it so they won't have to think about typing in the date, although if there is no automatic function I would be force to do that. Right now if I look at a quote at a later date it will have the present date (I want the date not to change).

Report •

October 26, 2011 at 10:23:36
The only way to make it truly automatic would be to use VBA to place the date in the cell.

For example, assuming the cell where the date will be stored is empty in your template, the code could check that cell and place a date in the cell if it is empty when the file is opened. If the cell already contains a date, then the code would do nothing.

However, that would mean that the Excel application on each machine would need to be set up to allow macros to run which may (or may not) be an issue.

A way to make it semi-automatic would be to pick a cell where you know that the user must enter/change a value as part of the quoting process. You could apply Data Validation on that cell such that no value could be entered/changed unless a date had already been entered in your date cell.

- Select a cell to apply the Data Validation to - not the date cell, but some other cell that you know the users must edit.
- Choose Data...Validation...Allow...Custom
- Formula (assumes A1 is your date cell):


- Uncheck the Ignore blank box
- Click the Error Alert tab
- Enter a message to the user, e.g. "Please enter a date in A1 before proceeding."

The cell where the Data Validation is applied will not accept any data entry until A1 contains a value that is recognized by Excel as a date.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question