Formula for current date in YYYYMMDD format

[bmontoni]

Hi All,

Is it possible to create a formula in excel to return the current date in YYYYMMDD format? If the month or day is only 1 digit, I need the formula to return 2 digits (e.g. 20220103 for January 3, 2022).

Here is the VBScript I would like to add that formula to:

Sub InputCurrentDateZPLP1()
'
' InputCurrentDateZPLP1 Macro
'
lastRow = Cells(Rows.Count, "A").End(xlUp).Row
Range("F2:F" & lastRow).FormulaR1C1 = "=TODAY()"

End Sub

Thanks in advance!

 

[Fluff]

Do you want it as an actual date, or as text?

 

[bmontoni]

Do you want it as an actual date, or as text?

Text

 

[Fluff]

Ok, how about

=TEXT(TODAY(),"yyyymmdd")

 

[bmontoni]

Ok, how about

=TEXT(A1,"yyyymmdd")

This would work but I need it to return current date

 

[Fluff]

In that case just change A1 to TODAY()
I have updated my previous post