Question: how to formula current date in excel?
Answer: To enter the current date as a static value, press CTRL + ; (semicolon). ... 
To enter the current time as a static value, press CTRL + SHIFT + ; (semicolon). ... 
To enter the current date and time as a static value, simply press CTRL + ; (semicolon), enter a space and press CTRL + SHIFT + ; (semicolon).