Create Date

[pjd]

Hi

When creating a template in excel, is it possible to insert a "creatdate" as in word.
ie If i opened a new sheet based on the template could a cell have the date it was created (eg todays' date) and after it was saved and opened on another day, would it still have todays' date.

I hope this makes sense

 

[Biff]

Hi pjd!

=TODAY()

Biff

-----Original Message-----
Hi

When creating a template in excel, is it possible to

insert a "creatdate" as in word.

ie If i opened a new sheet based on the template could a

cell have the date it was created (eg todays' date) and
after it was saved and opened on another day, would it
still have todays' date.

 

[RagDyeR]

Have you tried:
<File> <Properties> <Statistics> tab.

This might be what you're looking to create, that already exists in all XL
WBs.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi

When creating a template in excel, is it possible to insert a "creatdate" as
in word.
ie If i opened a new sheet based on the template could a cell have the date
it was created (eg todays' date) and after it was saved and opened on
another day, would it still have todays' date.

I hope this makes sense

 

[Bob Phillips]

You probably need VBA for this

Private Sub Workbook_Open()
Worksheets(1).Range("A1").Value =Format(Date,"dd mmm yyyy")
End Sub

This goes in the ThisWorkbook code module.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi

When creating a template in excel, is it possible to insert a "creatdate" as in word.
ie If i opened a new sheet based on the template could a cell have the

date it was created (eg todays' date) and after it was saved and opened on
another day, would it still have todays' date.