VBA Code to add date

[npereira]

Excellent !

That worked like a charm. Thansk again!

I have another question, but this has no revelance to this topic so
will start a new topic

 

[Mike Fogleman]

One note of caution using that on a template. Every time you open an invoice
made from that template the date will update to today's date and overwrite
the actual date the Invoice was created. I found this out the hard way
myself.
Mike F

 

[Dave Peterson]

Good point.

If that's a concern to the OP:

Option Explicit
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
With Me.Worksheets("sheet1").Range("e11")
if .value = "" then
.Value = Date
.NumberFormat = "mmmm dd, yyyy"
end if
End With
End Sub

Checks what's in that cell first.