Change date format layout from ddd.

[Mitchell]

Good afternoon!

After more than a couple of hours of googling and working on this, I have this formula:

=CHOOSE(WEEKDAY(TODAY()),"Sn","M","T","W","Th","F","Sa") & TEXT(TODAY(),"\.mmm-dd-yyyy")

which yields the correct format for the days for me like this (say today):

Th.Dec-10-2020

I need to switch the date format up in order to have items sort chronologically properly. So instead of, say, today's date of Th.Dec-10-2020, I need this:

2020-12-10.Th

How can this be done, please? If anyone can help, please advise. I've tried everything I know but I keep breaking the formula changing and moving the elements around so I know I'm missing something.

Thank you for any help in this regard!

(Oops, have incomplete title and can't see how to fix in editing. Title should read to change formatting from ddd.mmm.dd.yyyy to yyyy.mm.dd.ddd. Sorry!)

 

[sandy666]

maybe =TEXT(TODAY(),"yyyy.mm.dd.ddd") 2020.12.11.Fri
my today() is 11/12/2020
or I misunderstood

 

[Ezguy4u]

Sandy has a good solution but you can never have too many answers. I tried this formula and it seems to work for me.

=TEXT(TODAY(),"yyyy-mm-dd")& " ." &CHOOSE(WEEKDAY(TODAY()),"Sn","M","T","W","Th","F","Sa")

 

[Rick Rothstein]

Assuming you have to have the day name abbreviations you showed, here is another formula that seems to work...

=TRIM(TEXT(TODAY(),"yyyy-mm-dd.")&MID(" SnM T W ThF Sa",2*WEEKDAY(TODAY()),2))

 

[Mitchell]

Sandy has a good solution but you can never have too many answers. I tried this formula and it seems to work for me.

=TEXT(TODAY(),"yyyy-mm-dd")& " ." &CHOOSE(WEEKDAY(TODAY()),"Sn","M","T","W","Th","F","Sa")

My apologies in the delay in responding. I didn't see/get an email notification so going to see what I'm doing wrong as you all answered so very quickly! Much appreciated. I could finish my workbook now.

This did the trick, that's awesome! But so did Rick's, too! So using Sandy's as it's a little bit shorter but keeping both snippets. Thank you!