how do I put the day into my header with the date have it change d clyde 27.07.2006 16:40:02 I would like to have the day change like the date every day ex. monday 7/27/2006, tuesday 7/28/2006

Re: how do I put the day into my header with the date have it change d "Bill Ridgeway" <info[ at ]1001solutions.co.uk> 27.07.2006 16:46:12 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 "clyde" <clyde[ at ]discussions.microsoft.com> wrote in message news:B98FC86C-AB38-4D3B-8A30-F7EE86732982[ at ]microsoft.com... [Quoted Text] >I would like to have the day change like the date every day ex. monday > 7/27/2006, tuesday 7/28/2006

Re: how do I put the day into my header with the date have it change d "David McRitchie" <dmcritchie_xlmvp[ at ]verizon.net> 30.07.2006 11:35:34 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" <info[ at ]1001solutions.co.uk> wrote in message news:eaaqk1$nop$1[ at ]newsg3.svr.pol.co.uk... [Quoted Text] > 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> > > "clyde" <clyde[ at ]discussions.microsoft.com> wrote in message > news:B98FC86C-AB38-4D3B-8A30-F7EE86732982[ at ]microsoft.com... > >I would like to have the day change like the date every day ex. monday > > 7/27/2006, tuesday 7/28/2006 > >

Re: how do I put the day into my header with the date have it change d "David McRitchie" <dmcritchie_xlmvp[ at ]verizon.net> 30.07.2006 11:59:27 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" <dmcritchie_xlmvp[ at ]verizon.net> wrote in message news:O21HSy8sGHA.1512[ at ]TK2MSFTNGP03.phx.gbl... [Quoted Text] > 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" <info[ at ]1001solutions.co.uk> wrote in message news:eaaqk1$nop$1[ at ]newsg3.svr.pol.co.uk... > > 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> > > > > > "clyde" <clyde[ at ]discussions.microsoft.com> wrote in message > > news:B98FC86C-AB38-4D3B-8A30-F7EE86732982[ at ]microsoft.com... > > >I would like to have the day change like the date every day ex. monday > > > 7/27/2006, tuesday 7/28/2006 > > > > > >