How can you format a date in the header/footer of Excel sheet
 

When viewing a header/footer, I would like to insert a date in spcial format, how can I do this?


--------------------------------------------------------------------------------

Sam Sebaihi
Faculty
Western International University
Associate Programs

(alternate email)
Phone #: (405)315-8223 Time zone: Pacific Time

How can you format a date in the header/footer of Excel sheet
 

Sam

Whatever format is in the Windows Regional and Language Settings governs what
the format is in the header or footer.

These are very limited and Excel recognizes only a few for header formatting.

To get a header date format of your choosing use a cell reference for the
header.

e.g. In A1 enter =TEXT(DATE(2006,12,10),"dddd, mmmm d"&", "&"yyyy")

Then run this macro.

Sub CellInHeader()
With ActiveSheet
.PageSetup.CenterHeader = Range("A1").Value
End With
End Sub


Gord Dibben MS Excel MVP


On Sun, 10 Dec 2006 13:43:17 -0800, "SAM SEBAIHI"
wrote:

When viewing a header/footer, I would like to insert a date in spcial format, how can I do this?


--------------------------------------------------------------------------------

Sam Sebaihi
Faculty
Western International University
Associate Programs

(alternate email)
Phone #: (405)315-8223 Time zone: Pacific Time

How can you format a date in the header/footer of Excel sheet
 

Sam

Added info.

Excel only recognizes the Windows Short Date setting for headers and footers.

Also..............

You can edit the macro for RightHeader or LeftFooter or wherever you want.

Gord

On Sun, 10 Dec 2006 14:17:10 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Sam

Whatever format is in the Windows Regional and Language Settings governs what
the format is in the header or footer.

These are very limited and Excel recognizes only a few for header formatting.

To get a header date format of your choosing use a cell reference for the
header.

e.g. In A1 enter =TEXT(DATE(2006,12,10),"dddd, mmmm d"&", "&"yyyy")

Then run this macro.

Sub CellInHeader()
With ActiveSheet
.PageSetup.CenterHeader = Range("A1").Value
End With
End Sub


Gord Dibben MS Excel MVP


On Sun, 10 Dec 2006 13:43:17 -0800, "SAM SEBAIHI"
wrote:

When viewing a header/footer, I would like to insert a date in spcial format, how can I do this?


--------------------------------------------------------------------------------

Sam Sebaihi
Faculty
Western International University
Associate Programs

(alternate email)
Phone #: (405)315-8223 Time zone: Pacific Time

Gord Dibben MS Excel MVP

How can you format a date in the header/footer of Excel sheet
 

Thank you so much Gord. I do appreciate your help through out this
newsgroup.

--------------------------------------------------------------------------------
Sam Sebaihi Faculty Western
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Sam

Added info.

Excel only recognizes the Windows Short Date setting for headers and
footers.

Also..............

You can edit the macro for RightHeader or LeftFooter or wherever you want.

Gord

On Sun, 10 Dec 2006 14:17:10 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Sam

Whatever format is in the Windows Regional and Language Settings governs
what
the format is in the header or footer.

These are very limited and Excel recognizes only a few for header
formatting.

To get a header date format of your choosing use a cell reference for the
header.

e.g. In A1 enter =TEXT(DATE(2006,12,10),"dddd, mmmm d"&", "&"yyyy")

Then run this macro.

Sub CellInHeader()
With ActiveSheet
.PageSetup.CenterHeader = Range("A1").Value
End With
End Sub


Gord Dibben MS Excel MVP


On Sun, 10 Dec 2006 13:43:17 -0800, "SAM SEBAIHI"

wrote:

When viewing a header/footer, I would like to insert a date in spcial
format, how can I do this?


--------------------------------------------------------------------------------

Sam Sebaihi
Faculty
Western International University
Associate Programs

(alternate email)
Phone #: (405)315-8223 Time zone: Pacific Time

Gord Dibben MS Excel MVP

How can you format a date in the header/footer of Excel sheet
 

Thanks for the feedback Sam

If you decided to go with this and need a changing date just alter the A1

formula to =TEXT(TODAY(),"dddd, mmmm d"&", "&"yyyy")


Gord

On Sun, 10 Dec 2006 19:12:05 -0800, "SAM SEBAIHI"
wrote:

Thank you so much Gord. I do appreciate your help through out this
newsgroup.

--------------------------------------------------------------------------------
Sam Sebaihi Faculty Western
"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Sam

Added info.

Excel only recognizes the Windows Short Date setting for headers and
footers.

Also..............

You can edit the macro for RightHeader or LeftFooter or wherever you want.

Gord

On Sun, 10 Dec 2006 14:17:10 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Sam

Whatever format is in the Windows Regional and Language Settings governs
what
the format is in the header or footer.

These are very limited and Excel recognizes only a few for header
formatting.

To get a header date format of your choosing use a cell reference for the
header.

e.g. In A1 enter =TEXT(DATE(2006,12,10),"dddd, mmmm d"&", "&"yyyy")

Then run this macro.

Sub CellInHeader()
With ActiveSheet
.PageSetup.CenterHeader = Range("A1").Value
End With
End Sub


Gord Dibben MS Excel MVP


On Sun, 10 Dec 2006 13:43:17 -0800, "SAM SEBAIHI"

wrote:

When viewing a header/footer, I would like to insert a date in spcial
format, how can I do this?


--------------------------------------------------------------------------------

Sam Sebaihi
Faculty
Western International University
Associate Programs

(alternate email)
Phone #: (405)315-8223 Time zone: Pacific Time

Gord Dibben MS Excel MVP


Gord Dibben MS Excel MVP