Date in header that is not the current date

=?Utf-8?B?VFc=?=

Guest

Posts: n/a

17th Aug 2007

How do you insert a date other than the current date in a header on various
worksheets in a workbook?
For example, today'sa date is '16 August 2007', How do I ensure the header
for each worksheet shows the date '31 July 2007' and then change this on a
monthly basis?

« RE: Extract alpha from a cell | Protecting a 2007 Workbook continued... Bob Phillips you out there »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RE: Date in header that is not the current date	=?Utf-8?B?SkxhdGhhbQ==?=	Microsoft Excel Misc	0	17th Aug 2007 01:47 AM
current date in header	=?Utf-8?B?UmFjaGVsTg==?=	Microsoft Excel Setup	8	1st Jul 2005 07:56 PM
Calculate date difference between fixed date and current date	Dave Elliott	Microsoft Access Forms	3	23rd May 2005 03:54 AM
date difference using current date is no date is entered	=?Utf-8?B?QmV0c3lL?=	Microsoft Access Queries	5	7th Apr 2005 04:53 PM
Run Query from date to date, Print the from date to date in the header of the report?	Dustin Swartz	Microsoft Access Queries	1	25th Jan 2005 07:06 PM