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.

 

[Joe4]

If you just want to change the look, but keep it as a valid date, you can simply put =TODAY() in the cell and apply a custom format to the cell of "YYYYMMDD".
If you want it to be a text value, and not date, use the formula:

=TEXT(TODAY(),"YYYYMMDD")

 

[Kerryx]

1- Inspection Plan Log.xlsx
	E
42	20230815
Sheet3

Cell Formulas
Range	Formula
E42	E42	=TODAY()

 

[Sathsaj]

If you just want to change the look, but keep it as a valid date, you can simply put =TODAY() in the cell and apply a custom format to the cell of "YYYYMMDD".
If you want it to be a text value, and not date, use the formula:

=TEXT(TODAY(),"YYYYMMDD")

when I use this formula do you why I get YYYY08DD

 

[Joe4]

when I use this formula do you why I get YYYY08DD

You should get "20230815".

There is no way I can see the formula:

=TEXT(TODAY(),"YYYYMMDD")

returning:

YYYY08DD

unless you have some really bizarre regional settings.

Just to confirm, are you using Excel, or some other program?

 

[Joe4]

You could try switching to lower case and see if that makes a difference, i.e.

=TEXT(TODAY(),"yyyymmdd")

 

[Sathsaj]

You should get "20230815".

There is no way I can see the formula:

=TEXT(TODAY(),"YYYYMMDD")

returning:

YYYY08DD

unless you have some really bizarre regional settings.

Just to confirm, are you using Excel, or some other program?

Iam a german user

 

[Joe4]

What about all my other questions/suggestions?

1. Are you using Excel? If so, what version?

2. Did you try:

=TEXT(TODAY(),"yyyymmdd")

3. Do you use commas or semi-colons to separate formula arguments?
If semi-colons, you would need to change the formula, i.e.

=TEXT(TODAY();"yyyymmdd")

4. What do your date regional settings look like?

 

[Sathsaj]

You should get "20230815".

There is no way I can see the formula:

=TEXT(TODAY(),"YYYYMMDD")

returning:

YYYY08DD

unless you have some really bizarre regional settings.

Just to confirm, are you using Excel, or some other program?

Iam a german user

What about all my other questions/suggestions?

1. Are you using Excel? If so, what version?

2. Did you try:

=TEXT(TODAY(),"yyyymmdd")

3. Do you use commas or semi-colons to separate formula arguments?
If semi-colons, you would need to change the formula, i.e.

=TEXT(TODAY();"yyyymmdd")

4. What do your date regional settings look like?

1.Microsoft 365 for enterprise
2. Yes, the result is yyyy00dd
3. Semi -Colons which I actually used

 

[Joe4]

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:

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