Question: how to change date format in excel header and footer?
Answer: Go to file > page setup then select the header/footer tab. have selected. it to be "dd-mm-yy".