How to keep date static

[Sumeluar]

Hello friends,

I've been using this:

Range("G2").FormulaR1C1 = "=TEXT(NOW(),""MMMM dd yyyyy"")"

and even when I protect the sheet the date goes to the current one, How can I make it static?

Kind Regards!

Sumeluar

 

[acw]

Hi

How about

Range("G2").Value = Format(Now(), "MMMM dd yyyy")

Tony

 

[jindon]

Hi
try

Range("G2").Value = Format(Date,"MMMM dd yyyyy")

 

[Sumeluar]

Great job you guys!

Kind Regards!

Sumeluar