Convert Date to YYYYMMDD

[Sathsaj]

Hi I would like to convert a date =today() to YYYYMMDD format.
Is there a way, most of the search shows YYYYMMDD to other formats.

 

[Sathsaj]

I think item 4 is the one that we need the answer to, as I think that holds they key.

If you follow the instructions listed here: How to set up Regional Settings in Windows 10 - Power Community, we want to get to where it shows this:
View attachment 97249

When you get to this screen, what does it show for you for Short and Long Date?

thanks for the Tip, in my case it should be =TEXT(TODAY(),"JJJJMMTT")
Jahr-Year
Monat-Month
Tag-Day

thanks Joe4 for the help!

 

[Joe4]

You are welcome.
Yes, that was the key. You have different date regional settings so those common ones won't work for you.