Newbie question--chg slashes in date format to dashes

[friedrice]

I want to format page header date as mm-dd-yyyy and not the default date format of mm/dd/yyyy in my right-hand side page header box. Want dashes not slashes. See attached image of what I have right now. Thanks

 

[footoo]

Format Date in Header or Footer in Excel Excel Tutorial

Learn how to format the date in Excel's header or footer using VBA code. Customize your date format in headers or footers easily!

officetuts.net

 

[Glenn Kennedy]

CTRL-1, custom, and enter mm-dd-yyyy

 

[friedrice]

CTRL-1, custom, and enter mm-dd-yyyy

OK but what would I write in the "Right Section" box in image I attached?

 

[Glenn Kennedy]

Sorry! Running on "no coffee so far" today. Try here for instructions:

Blog

Causal replaces your spreadsheets with a better way to build models, connect to data (accounting, CRM), and share dashboards with your team. Sign up for free.

www.causal.app

 

[Peter_SSs]

Sorry! Running on "no coffee so far" today. Try here for instructions:

Blog

Causal replaces your spreadsheets with a better way to build models, connect to data (accounting, CRM), and share dashboards with your team. Sign up for free.

www.causal.app

I believe that is also referring to worksheet cells, not the page layout header.

@friedrice
Have you studied the link in post #2? That details the steps required using vba code in the BeforePrint event.