Month and Year in Excel Header Mac

[excellence]

I currently have this &[Date] &[Time] in the right part of a footer on an Excel spreadsheet. I am trying to put a similar "formula" in the top left header of the same spreadsheet, but would like it to put in the current month and year automatically in the format Mmmm yyyy January 2024.

I have tried to modify my footer without success, though I believe this should be able to be done.
Thanks

 

[excellence]

Sorry, also, seems I have to click twice to get the date change

 

[Peter_SSs]

When posting vba code in the forum, please use the available code tags. It makes your code much easier to read/debug & copy. My signature block below has more details. I have added the tags for you this time.

Where is the code?
It should be in the ThisWorkbook module.

 

[excellence]

When posting vba code in the forum, please use the available code tags. It makes your code much easier to read/debug & copy. My signature block below has more details. I have added the tags for you this time.

Where is the code?
It should be in the ThisWorkbook module.

View attachment 106116

I redid it and copied to workbook, but it seems code is also in worksheet.. looks like the properties are different in both. Thanks for your patience…but tough to get for me. Looks like it is working now.

 

[Peter_SSs]

redid it and copied to workbook, but it seems code is also in worksheet.. l

If that same code is in one or more of the worksheet modules then delete it from there. It should only be in the ThisWorkbook module.