Here is how the Power Automation flow (the automation program/script), that will do the task you need, will look.
The only drawback is that with a free account you can not run the flow unattended. You will have to automatically run the Power Automation console at Windows start-up and then, every day, manually run the flow that will create a new folder with the current date name.
The flow gives you the option to choose the base folder where you want to store your daily folders, checks if a daily folder for the current day was already created and if not, it creates one and opens Windows Explorer in it.
You could automate a lot of repetitive tasks with Power Automate, without being a programmer.