INSERT DATE in Special FORMAT via MACRO

[masson426]

Hi,

I am looking for a Macro which insert date in cell A1 in sheet in the follwing format.

##DATA[20111201]

FORMAT
##DATA[YearMonthDate]

If any body can help me for this format via macro codes.

With best regards,
Masson

[masson426]

Hi,

Is anyone found the solution?

It will be ok if I find How can I insert date in this format?

[20111201]

best,

[masson426]

Hi I can insert date in this 2011 12 01 format with Swedish or chinees date format.
But 20111201 I want to now remove the space in the date.

or

This format also know as "iso 8601 date format" anyone provide me VB Macro for "iso 8601 date format"

Any Idea?