how do I put the day into my header with the date have it change d

C

clyde

I would like to have the day change like the date every day ex. monday
7/27/2006, tuesday 7/28/2006
 
B

Bill Ridgeway

In the cell you want the message displayed enter the formula -
=TODAY()
Format that cell as custom and, in 'type', enter
"The message you want displayed" dd/mm/yyyy

You will also need to make sure the spreadsheet is updated manually. To do
this-
Click on <Tools><Options><Calculations><Manual>

Regards.

Bill Ridgeway
Computer Solutions
 
D

David McRitchie

Hi Clyde,
The day of the week will be in proper case, but
simply use a custom number format.
Format, Cells, number, custom
dddd mm/dd/yyyy (for US type of date formatting)

You can use dddd m/dd/yyyy as in you example, but
I think you would want the digits to line up.

Excel dates and times are stored together, time being a
fraction of a day.

I have no idea why Bill suggested turning off automatic
calculation. Changing to manual would mean you would have
to use F9 every time you wanted to see what you have.
Perhaps he was thinking of trying to keep the current date
as a constant and that method would not work. To enter
Today's date and time as a constant, you would enter
Ctrl+semi-colon space Ctrl+Shift+colon
(actually since you would have a format, you don't need to
include the space).

For more information on date and time with examples, see
http://www.mvps.org/dmcritchie/excel/datetime.htm
http://www.cpearson.com/excel/datetime.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
D

David McRitchie

Hi Clyde,
Sorry misread your complete question, because part of the question
was in the headers so most people including myself would not
see that you wanted customized date in you header (or footer)
because that was not conveyed in the body of the question.

For that you would need a macro, see
http://www.mvps.org/dmcritchie/excel/pathname.htm#modify

.LeftHeader = Format(Now(), "dddd mm/dd/yyyy"---HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]My Excel
Pages: http://www.mvps.org/dmcritchie/excel/excel.htmSearch Page: http://www.mvps.org/dmcritchie/excel/search.htm "David
McRitchie said:
Hi Clyde,
The day of the week will be in proper case, but
simply use a custom number format.
Format, Cells, number, custom
dddd mm/dd/yyyy (for US type of date formatting)

You can use dddd m/dd/yyyy as in you example, but
I think you would want the digits to line up.

Excel dates and times are stored together, time being a
fraction of a day.

I have no idea why Bill suggested turning off automatic
calculation. Changing to manual would mean you would have
to use F9 every time you wanted to see what you have.
Perhaps he was thinking of trying to keep the current date
as a constant and that method would not work. To enter
Today's date and time as a constant, you would enter
Ctrl+semi-colon space Ctrl+Shift+colon
(actually since you would have a format, you don't need to
include the space).

For more information on date and time with examples, see
http://www.mvps.org/dmcritchie/excel/datetime.htm
http://www.cpearson.com/excel/datetime.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Bill Ridgeway said:
In the cell you want the message displayed enter the formula -
=TODAY()
Format that cell as custom and, in 'type', enter
"The message you want displayed" dd/mm/yyyy

You will also need to make sure the spreadsheet is updated manually. To do
this-
Click on <Tools><Options><Calculations><Manual>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top