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.