Question: how to set live date format in excel?
Answer: Select the dates whose format your want to change, or empty cells where you want to insert dates.
Press Ctrl+1 to open the Format Cells dialog. ... 
In the Format Cells window, switch to the Number tab, and select Date in the Category list.
Under Type, pick a desired date format.