Create Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi pjd!

=TODAY()

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

When creating a template in excel, is it possible to
Click to expand...
insert a "creatdate" as in word.
ie If i opened a new sheet based on the template could a
Click to expand...
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.
 
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
 
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)

pjd said:
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
Click to expand...
date it was created (eg todays' date) and after it was saved and opened on
another day, would it still have todays' date.
 
Back
Top