This is a bit basic but the way I've achieved this is to actually go into the
footer and type in the date exactly as you want it to appear.

"David" wrote:

Hi, I would like to have my date format in the header/footer to be
dd/MMM/yyyy. However the 'Date Button' in the header screen only gives me a
format of dd/MM/yyyy. My Regional settings are as i need them to be. Date
format in my actual worksheet is as i want it.....just not in the
header/footer ?