ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   auto entry of a date (https://www.excelbanter.com/excel-worksheet-functions/8328-auto-entry-date.html)

Richard Rosell

auto entry of a date
 
I have created a template for a worksheet I use frequently to record client
information. I am interested in finding a function that will permit me to
automatically insert the date I first use create a document based on the
template (i.e. a create date) that does not change when I open the document
on subsequent occassions.

Does any one have a suggestion as to how I might accomplish this.

Thanks

Richard



Frank Kabel

Hi
see:
http://www.mcgimpsey.com/excel/timestamp.html

"Richard Rosell" wrote:

I have created a template for a worksheet I use frequently to record client
information. I am interested in finding a function that will permit me to
automatically insert the date I first use create a document based on the
template (i.e. a create date) that does not change when I open the document
on subsequent occassions.

Does any one have a suggestion as to how I might accomplish this.

Thanks

Richard




Richard Rosell

Thanks very much Frank.

Richard

"Frank Kabel" wrote in message
...
Hi
see:
http://www.mcgimpsey.com/excel/timestamp.html

"Richard Rosell" wrote:

I have created a template for a worksheet I use frequently to record
client
information. I am interested in finding a function that will permit me
to
automatically insert the date I first use create a document based on the
template (i.e. a create date) that does not change when I open the
document
on subsequent occassions.

Does any one have a suggestion as to how I might accomplish this.

Thanks

Richard







All times are GMT +1. The time now is 07:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com