Question

Locked

Date Stamp in Excel

By johnsonsoftware ·
I am looking or a way to date stamp Excel spreadsheets with a creation date that won't change when the spreadsheet is updated. I do not want to have to key in the date, it should be an automatic date stamp. I saw something that said naming the formula '=TEXT(TODAY(),"dd-mmm-yyyy")' and using that range name where you want the date stamp would work, however, everytime I re-open the worksheet, the today() function updates the date. Back in the day, I used to create date stamps in a Lotus macro that didn't change. Anybody know a way?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Use Macro Workbook_Open()

by davidliu In reply to Date Stamp in Excel

Private Sub Workbook_Open()
Sheets(1).Activate
If Range("A1") = "" Then Range("A1") = Now()
End Sub

Collapse -

To Stamp Date or Time Only

by vo_yager In reply to Date Stamp in Excel

To Stamp Date Only, press Ctrl + ;

To Stamp Time Only, press Ctrl + Shift + :

If you want to use Macro
1. Press Alt & F11 [Open the VB Editor]
2. Select Module from Insert Menu
3. Copy & Paste below code into the Module
4. =fDate() [Use it like any Function]

Option Explicit
'---------------------------------------------------------------------------------------
' Function : fDate()
' Purpose : Add a fixed date to a cell
' Date : 20-Apr-12
' Website : www.rain-forest-forum.com
'---------------------------------------------------------------------------------------
'
Function fDate()
fDate = Date
End Function

Back to Software Forum
3 total posts (Page 1 of 1)  

Software Forums