Date in header that is not the current date

Posted to microsoft.public.excel.misc

external usenet poster

Posts: 3

Date in header that is not the current date

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date in header that is not the current date	JLatham	Excel Discussion (Misc queries)	0	August 17th 07 01:47 AM
Figuring Vacation Hrs. Earned using Current Date minus Hire Date	Sharon	Excel Worksheet Functions	6	May 3rd 07 10:32 PM
Make date change in excel to current date when opening daily?	jamie	Excel Discussion (Misc queries)	3	March 1st 06 03:37 PM
current date in header	RachelN	Setting up and Configuration of Excel	8	July 1st 05 07:56 PM
Calculating days between current date and a date in future NETWORKDAYS() function	Faheem Khan	Excel Worksheet Functions	2	February 10th 05 07:18 PM

All times are GMT +1. The time now is 07:33 AM.

Menu

About Us