Is there something like Word's "CREATEDATE" function in Excel?
 

I've created a lovely invoice in Excel for my company. When I generate a new
invoice from the template it puts in the date using the TODAY() function, but
unfortunately this updates if I ever open the invoice again to look at it.

In Word there is a "CREATEDATE" function which inserts the date that the
file was created first, and never after does it change. Is there any way to
accomplish this same task in Excel?

Thanks,
Michael
mleenheer @ yahoo.com

ML,
Keyboard shortcut to date stamp is put your cursor in the cell you want
and push -- ctrl ; --(thats ctrl and semicolon)
Time stamp would be -- ctrl shift ; -- (ctrl shift semicolon)
This help ?
Dave
- ML - Wrote:
I've created a lovely invoice in Excel for my company. When I generate
a new
invoice from the template it puts in the date using the TODAY()
function, but
unfortunately this updates if I ever open the invoice again to look at
it.

In Word there is a "CREATEDATE" function which inserts the date that
the
file was created first, and never after does it change. Is there any
way to
accomplish this same task in Excel?

Thanks,
Michael
mleenheer @ yahoo.com


--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=389913

I'm not aware of any such function, but there is another way to freeze the
date. When you open a new invoice from the template, click on the date cell
and press these keys: Ctrl and semicolon. This will change the entry to a
permanent date.

"- ML -" <- ML wrote in message
...
I've created a lovely invoice in Excel for my company. When I generate a
new
invoice from the template it puts in the date using the TODAY() function,
but
unfortunately this updates if I ever open the invoice again to look at it.

In Word there is a "CREATEDATE" function which inserts the date that the
file was created first, and never after does it change. Is there any way
to
accomplish this same task in Excel?

Thanks,
Michael
mleenheer @ yahoo.com

ML,
If your interested in a macro you could use something like this

'Insert current date in active cell.
Sub InsertDate()
With ActiveCell
.Value = Now
.NumberFormat = "mm/dd/yy"
End With
End Sub

If you use it with something like a Button, Logo, Pic etc to run the
macro,
it will not update automatically, only when you click the button.
You could target a cell insead of "on selection".

This help ?
Dave
- ML - Wrote:
I've created a lovely invoice in Excel for my company. When I generate
a new
invoice from the template it puts in the date using the TODAY()
function, but
unfortunately this updates if I ever open the invoice again to look at
it.

In Word there is a "CREATEDATE" function which inserts the date that
the
file was created first, and never after does it change. Is there any
way to
accomplish this same task in Excel?

Thanks,
Michael
mleenheer @ yahoo.com


--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=389913

You could use an Event Procedure. I put this into the template's workbook code.
Right click on the Excel icon to the left of the File Menu. Pick View Code.
Change the drop-down on the left to Workbook. Make sure Private Sub
Workbook_Open() shows on the right drop-down.

You should change A1 to whatever cell you want the date to appear in. This
macro will insert the current date into the cell specified for every file
created from the template, unless there is something else in the cell
already. This should stop the date from changing if you open the file up in
the future...as long as you never delete the date.

Private Sub Workbook_Open()
Dim x As Range
Set x = Range("A1")

If x.Value = "" Then x.Value = Date
End Sub

--
tj


"- ML -" wrote:

I've created a lovely invoice in Excel for my company. When I generate a new
invoice from the template it puts in the date using the TODAY() function, but
unfortunately this updates if I ever open the invoice again to look at it.

In Word there is a "CREATEDATE" function which inserts the date that the
file was created first, and never after does it change. Is there any way to
accomplish this same task in Excel?

Thanks,
Michael
mleenheer @ yahoo.com

Thanks all!! Appreciate the help.

Michael


"tjtjjtjt" wrote:

You could use an Event Procedure. I put this into the template's workbook code.
Right click on the Excel icon to the left of the File Menu. Pick View Code.
Change the drop-down on the left to Workbook. Make sure Private Sub
Workbook_Open() shows on the right drop-down.

You should change A1 to whatever cell you want the date to appear in. This
macro will insert the current date into the cell specified for every file
created from the template, unless there is something else in the cell
already. This should stop the date from changing if you open the file up in
the future...as long as you never delete the date.

Private Sub Workbook_Open()
Dim x As Range
Set x = Range("A1")

If x.Value = "" Then x.Value = Date
End Sub

--
tj


"- ML -" wrote:

I've created a lovely invoice in Excel for my company. When I generate a new
invoice from the template it puts in the date using the TODAY() function, but
unfortunately this updates if I ever open the invoice again to look at it.

In Word there is a "CREATEDATE" function which inserts the date that the
file was created first, and never after does it change. Is there any way to
accomplish this same task in Excel?

Thanks,
Michael
mleenheer @ yahoo.com