Datumsformat in Fußzeile ändern (Excel Mac)

Hi Thomas625

Changing the formatting for header & footers can be done only with VBA as of now.

the date format is based on your regional system settings.

you can use the below code & run the same on the active workbook before printing the document.

Sub ChangeFooterDateFormat()
    ActiveSheet.PageSetup.LeftFooter = Format(Date, "dd.mm.yyyy")
End Sub

If you wish to display it to a different place in the header or footer, then change the part of the above code "LeftFooter" to any one of these [CenterHeader, CenterFooter, RightFooter, LeftHeader]

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more