On page setup I know how to add the currecnt date to the footer, but can the
creation date be added to the footer?

The "kludge" method is to type the date into the tab and add the tab to the
footer.

I am quite happy to do this using VBA or a macro, but can find no refernce
on how to do this.

If this is only possible in recent versions of Excel, please indicate which
version of Excel you are using.