To-days date in Header or Footer - Excel 2000

Hello,

I would like to-days date to display in the Header or Footer of a 
spreadsheet each time it is printed.  I know you can use =TODAY() in the 
body of a worksheet and wonder if there is a way to use it in the header or 
footer.

Excuse my ignorance .. as you can see I am not a expert in Excel .. some 
help would be much appreciated.

Abay 


0
abcd1 (40)
5/3/2007 2:18:12 AM
excel 39879 articles. 2 followers. Follow

3 Replies
756 Views

Similar Articles

[PageSpeed] 39

Wed, 2 May 2007 19:18:12 -0700 from Abay <abcd@aol.com>:
> Hello,
> 
> I would like to-days date to display in the Header or Footer of a 
> spreadsheet each time it is printed.  I know you can use =TODAY() in the 
> body of a worksheet and wonder if there is a way to use it in the header or 
> footer.
> 
> Excuse my ignorance .. as you can see I am not a expert in Excel .. some 
> help would be much appreciated.

Click View | Header and Footer. 

On the dialog box, click Custom Header or Custom Footer.

You get a second dialog with a left, center, and right section. Click 
into the one of those where you want the date, then little calendar 
icon *or* just type
     &[Date]

-- 
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
                                  http://OakRoadSystems.com/
0
5/3/2007 3:57:45 AM
Thank you so much and apologies for I should have thought of that myself ... 
Your help is much appreciated.

Abay
"Stan Brown" <the_stan_brown@fastmail.fm> wrote in message 
news:MPG.20a327c5faa80c5198ac02@news.individual.net...
> Wed, 2 May 2007 19:18:12 -0700 from Abay <abcd@aol.com>:
>> Hello,
>>
>> I would like to-days date to display in the Header or Footer of a
>> spreadsheet each time it is printed.  I know you can use =TODAY() in the
>> body of a worksheet and wonder if there is a way to use it in the header 
>> or
>> footer.
>>
>> Excuse my ignorance .. as you can see I am not a expert in Excel .. some
>> help would be much appreciated.
>
> Click View | Header and Footer.
>
> On the dialog box, click Custom Header or Custom Footer.
>
> You get a second dialog with a left, center, and right section. Click
> into the one of those where you want the date, then little calendar
> icon *or* just type
>     &[Date]
>
> -- 
> Stan Brown, Oak Road Systems, Tompkins County, New York, USA
>                                  http://OakRoadSystems.com/ 


0
abcd1 (40)
5/3/2007 4:25:37 AM
Wed, 2 May 2007 21:25:37 -0700 from Abay <abcd@aol.com>:
> Thank you so much and apologies for I should have thought of that myself ... 
> Your help is much appreciated.

Glad it was helpful - thanks for letting us know.

-- 
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
                                  http://OakRoadSystems.com/
0
5/4/2007 10:58:18 PM
Reply:

Similar Artilces:

Date Find on or Prior to Today
I need a view that will find records if a date field is "on or before" to today. While "on or before" is an operatior, you can only set this to a specific date. Any ideas on how to make this dynamic would be appreciated. Thanks! AAA, If you want to see Dates from anytime prior to the present day, using the Last X Years will suffice. "AAA" wrote: > I need a view that will find records if a date field is "on or before" to > today. While "on or before" is an operatior, you can only set this to a > specific date. Any ideas...

Changing dd/mm/yy to the day of the week
Hi, Am looking for a macro or whatever which will change a set of dates into the corresponding week day. Ie: I have a column of dates in this format: 01/01/03 thru to 16/10/03. I want to write a quick macro which will then drop into an adjacent cell, the day of the week that each day is, so in column 'A' we have the dates (01/01/03) and in column 'B' we have the day that that date was ie Wednesday. any help would be great. cheers On Thu, 16 Oct 2003 02:13:51 -0700, Gerald wrote: > Hi, > > Am looking for a macro or whatever which will change a set > of ...

Date Calculations
I have to create a formula in excel that takes a date (4-1-2010) and subtracts another date from it (2-1-2008) and gives me the remainder of months. Any ideas? How do you define a month difference? 30 days? Calendar months? What about months with different numbers of days. E.g., how many months between 28-Feb and 31-March. 1? 1+3/30? You need to define how the months should be calculated. At its simplest, just subtract one date from the other and divide by 30. That will give one of several possible answers. Cordially, Chip Pearson Microsoft Most Valuable Professional, Excel,...

ListCtrl header right click
I want to bring up a context menu when the user clicks on the grey headers across the top of the columns in my CListCtrl class. What event do I have to use to catch a right click on a CListCtrl's header. I have tried OnNcRButtonDown in the list control, but it isn't hit, so something else must be catching the right click event. If I have to subclass the header control and catch the click in my specialised class, then how do I use my own class rather than the CListCtrl's normal class as it's creation is automatic? Thanks for any tips. "GT" <ContactGT_rem...

Layer color doesn't affect line ends (Visio 2000)
I have got the effect, that the layer color doesn't affect the color of the line ends (e.g. arrows). They will be shown still in the original color. Does anyone has a clue what I have to change, that the layer color affect all shapes on it? Thanks, T. ...

30, 60, 90 days late and due within 14 days
I am working on a spreadsheet that will calculate late suspenses. Basically I have 3 different types of late suspenses and am looking to calculate between 0 and 30 days late, 30 - 60 days late, 60 - 90 days late and over 90 days and each of these time frames for the three categories. Here is what my spread sheet looks like: Name ID TYPE SUSP DAYS OVER DUE UNIT WOOD 6470 N/A 18-Mar-05 (234) A SMITH 7453 UNIT 22-APR-05 (199) B JONES 9741 CO 1-Nov-05 (6) C ...

How to get only the year in the date format in Access
How to get only the year in the date format I.e in the table in need to display only year E.g 2005 - should be display " 05" automatically Custom format the cell as: yy -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "yanu" <yanu@discussions.microsoft.com> wrote in message news:14CE9F60-F7B9-467A-8C16-71088C31BEBA@microsoft.com... > How to get only the year in the date form...

Customer Vendor Consolidation transfer date
When working in the Customer/Vendor Consolidation window, I am trying to change the Transfer Date to a prior day but the Transfer Date keeps reverting back to the User Date. The only way I have been able to work around this is to change my User Date to the date I want the transfer to post. Is there a problem with this window? We are on GP 10.0 Sue, I saw this issue once in the past where our customer was not registered for Multicurrency. Can you confirm that you do not have Multicurrency registered (or enabled)? Apparently something about that field requires MC. I do not know o...

Image size in Publisher 2000
I recently upgraded from Publisher 98 to 2000. Newsletters with photos in are now a ridiculous size and become even bigger when converted to pdf. Too large to email. When the photos are deleted the file size reduces. Did not have this problem with Publisher 98 and am my wits end. Am running Windows 98SE. What have I done as I have never had this problem before? Ann G Hi Ann, Microsoft Publisher files are abnormally large: http://www.mvps.org/publisher/section_01.html This is quite normal, as Publisher converts all bitmapped image formats to uncompressed bitmaps when you insert...

Format dates
Hello, I would like to format a dates in column A to a specific format (either directly in column A or column B) The format is ddmmy. So for example 18/1/2006 should appear as 18016 and 3/12/2006 should appear as 03126. Is there a way to do this? Using "format cells/date" wont do the trick. Any suggestions please? Thank you, Steven. Hi! Use a CUSTOM format of ddmmy. Select the cells Goto Format>Cells>Number>Custom In that little box on the right type: ddmmy OK out Biff "steven" <steven@discussions.microsoft.com> wrote in message news:2B7AB99C-9...

Date formatting in Pivot Chart
Hi, I'm trying to create a pivot chart and the date field is not formatting properly - the format comes out different from that of the pivot table. How can I fix this? Format axis doesn't give me an option for date format. In the pivot table, right-click the date field button, and choose Field Settings. Click the Number button, and select a date format Click OK twice The chart should show the selected format. JessicaMc wrote: > Hi, > > I'm trying to create a pivot chart and the date field is not formatting > properly - the format comes out different from that o...

send mail every days
Hello friends, Have a question about outlook 2007. I need to run a macro every days, this macro send a mail with information of a SQL. Have the macro created and run succesfull but how i can to do for run every days automatically ? is possible schedulle this macro ? Thanks in advnace and sorry by my english, Christian Wis. This might help you: http://www.vboffice.net/sample.html?lang=en&mnu=2&smp=10&cmd=showitem -- Best regards Michael Bauer - MVP Outlook Category Manager - Manage and share your categories: SAM - The Sending Account Manager: &...

Correct dates for transactions.
Hello, i don't know if the credit cards are managed differently in other countrys, but here in Mexico, they have a cut date, and a due date to pay the charges. For this when i insert a transaction for a credit card in Money, the date doesn't correspond with the payment date and when i see cash flow reports i can not have the correct charges. I don't know if there is a way in money to set a cut date and a due date for credit cards. In microsoft.public.money, Jorge Hdez wrote: >Hello, i don't know if the credit cards are managed differently in other >countrys, but her...

How far ahead of due date?
Hi all: The answer to this question probably varies depending upon one's banking institution but I'll ask the question anyway... :-) Typically how far ahead of the actual due date of bill should we schedule payment of that bill in Money when paying online using a bill pay service? Thanks -Mike You answered your own question. Depends on the FI. -- Regards Bob Peel, Microsoft MVP - Money For UK tips & fixes see http://support.microsoft.com/default.aspx?scid=fh;EN-GB;mny. I do not respond to any emails that I have not specifically asked for. "Mike" <Mike@di...

How do I stop 1 day tasks splitting over 2 days?
I am using Project 2003 and it has got an annoying habit of splitting most tasks with a duration of 1 day into 7 hours of work on one day and 1 hour of work the following day when you look at them within the Resource Usage view. This is mucking up my Gantt chart as the tasks effectively look as if they are 2 day tasks (although the duration cell definitely says 1 day). Any idea what is causing the problem and how do I fix it? Things to note: - The project calendar and resource calendars are definitely showing 8 hour working days (8-12 then 1-5) so that isn’t causing the probl...

Roman Numeral Page Numbers for Footers
In a footer, using &[page] function for page numbering, how can I change the number format to roman numerals (i.e., I, II, III, IV, etc.)??? Stella, As far as I know, this cannot be done. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Stella Kimura" <StellaKimura@discussions.microsoft.com> wrote in message news:6BDBC68E-2EFD-4E8A-A36E-2E7F8EE01B9C@microsoft.com... > In a footer, using &[page] function for page numbering, how can > I change the > number format to roman numerals (i.e., I, II, III, IV...

Calendar day not days
I am trying to figure a way in which I can add a specified number of calendar days to a date (ex: 9/21/2006 + 14 days = Calendar date). I thought it would be an easy thing to do, but when I try what is on MS help, I get the total days from 1 Jan 1900 and can't figure out how to convert it to the calendar day. Can anyone help out in figuring this formula out. Dan (Still going in circles) Dan, All dates are actually a count of the number of days since 1 Jan 1900 but are just formatted to look like dates. Try re-formating the number you get as a date. -- HTH Sandy In Perth, the ancie...

Years, Months, Days, Hours, Minutes, Seconds Formula?
Hi Everyone, Could anyone PLEASE help me with a single cell formula that would take the difference between TWO cells containing Dates AND Times, and return the elapsed difference in the following format: "3 Years, 9 Months, 15 Days, 14 Hours, 8 Minutes, 16 Seconds" I've been trying all day to come up with it, but so far have only managed to do the date part! I would be extremely grateful for any help anyone can offer. Thank you. Hi Darrell, As long as you have date & time in each cell as entered by Excel you simply subtract the earlier timestamp from the later ti...

Viewing attachments in Outlook 2000
Is it possible to view attachments in line with Outlook 2000? I know in Outlook Express there is an option for this and the pics just show up right in the email. However I cannot find a way to do this in Outlook and have to right click and View attachment 1 at a time which is a pain. Any help appreciated. Ray Outlook can only display images "inline" if the sender used HTML or Rich Text format for the message and embedded the image into the body. If the image was sent as an attachment, you will always receive it as an attachment. -- Jocelyn Fiorello MVP - Outlook *** Mes...

Excel2007 VBA
If I create a PivotTable with a field called DATE containing dates formatting as dd/mm/yy, I then use this macro to remove Saturdays and Sundays from the PivotTable. Except it reads the dates a mm/dd/yy until they are 'out of scope' and then they are read as dd/mm/yy. Why? Sub HideWeekendsFromPivotTable() Dim pivotName As String Dim pivotDate As Date Dim z, pivotCount As Long pivotName = ActiveSheet.PivotTables(1).Name With ActiveSheet.PivotTables(pivotName).PivotFields("Date") pivotCount = .PivotItems.Count ...

Calculating Time over days
I am trying to calculate hours since I last worked in a daily log. Th issue I have is if there is a day off in between, I need it to go t the previous day totaling the Hours Off. (File Attached) Any and all suggestions appreciated. Thanks, Ti Attachment filename: time calculation.xls Download attachment: http://www.excelforum.com/attachment.php?postid=61019 -- Message posted from http://www.ExcelForum.com Check out the NETWORKDAYS function in Help. On Tue, 6 Jul 2004 17:15:12 -0500, TimSmi <<TimSmi.18ztja@excelforum-nospam.com>> wrote: >I am trying to ...

AUTO DATE RECOGNITION
HOW CAN I STOP PART NUMBERS WHICH HAVE DASHES IN THEM BEING CONVERTED INTO DATES WHEN I DO A DATA IMPORT INTO EXCEL? Yell real LOUD. That does it for me. Seriously, please don't use all caps for subject or body of msg. It is considered shouting and rude. Try pre-formatting your destination range to text. -- Don Guillett SalesAid Software donaldb@281.com "TONY" <anonymous@discussions.microsoft.com> wrote in message news:AD32B08C-CD73-4585-B706-6F29B17894D0@microsoft.com... > HOW CAN I STOP PART NUMBERS WHICH HAVE DASHES IN THEM BEING CONVERTED INTO DATES WHEN I DO A ...

Default Dates
I have a query that calculates records between two dates as Between [Beginning Date] And [Ending Date] Is there a way to show a default value for the beginning and ending dates in the input boxes rather than having to enter a date every time? Thank you for any help Paul. Yes. Open the form in design view, click on the text box, right click, scroll to bottom, click on Properties, enter a default value or formula and select the format. -- Build a little, test a little. "Ampridge" wrote: > I have a query that calculates records between two dates as &g...

Date Part or Date Value
I have a form such that there are labels for each of the month and the control being a checkbox such that if a task is done in a particular month, then the checkbox for this month is ticked. I would like to add a textbox on this form and link it to a table such that if the checkbox for ie. Jan is checked then the textbox should show Jan-2008 if the year entered was 2008. This would then be stored in a table to use for calculations later on. Please help. On Sun, 3 Feb 2008 20:29:27 -0800 (PST), c8tz <ccholai@gmail.com> wrote: >I have a form such that there are labels for each of t...

Cell gets formatted as Hijri date (Arabic date)
Hi, on some of the PCs at work, when the user enters a value starting with 'a' or 'A' followed bya number from 1 to 12, it gets displayed as Arabic text representiing the month. When I look at the formatting of the cell, it shows as Custom with type set as "B2d-mmm". Deleting the type has no effect, it just comes back. Microsoft KB 871138 (http://support.microsoft.com/kb/871138) shows how to enter Arabic dates: "To enter Hijri date, type A or a in front of the date entry For example, you can enter the short date 'a9/25/20', which will be interpreted as H...