How to replace the current numeric date with the name of the current day, the current day, the month in words and the year using the TODAY() function?

Question

excel

Good evening!
I came across the fact that inside the cell where the current date is located, generated by the TODAY() function in an Excel table, for example: 1.31.2020, you need to replace it with the following format for displaying the date that I will need:
пятница, 31. январь 2020.
I tried to apply custom data formats in the cell settings where the date is located and for some reason did not work. I tried to work with the TEXT() format and the same song came out ...
Tips on the Internet did not help;-(
Guys, tell me, please, with what formulas in Excel I can correctly implement my date display format inside the TODAY() function which I will need?
Thanks in advance!

Answer 1

Answer 2

https://www.planetaexcel.ru/forum/