Save date to workbook.
 

I have a workbook that I copy & paste into a pervious days folder. It has
22 tabs with multiple pages, when ever I go back and print a page that I need
it has the current date, and not the date it is from. If I take the =today()
formula off each page is there any other way to get the date it is from to
print to the pages I want?
--
Medzzz

Save date to workbook.
 

TODAY() is a volatile function and will change every day.

Copy and paste special as a value.

Or enter a date using CTRL + ;(semi-colon) which will not update tomorrow.


Gord Dibben MS Excel MVP

On Thu, 28 Feb 2008 16:34:00 -0800, CevaClerkII <Joel
Zurba/NA/TNT/TPG@Logistics wrote:

I have a workbook that I copy & paste into a pervious days folder. It has
22 tabs with multiple pages, when ever I go back and print a page that I need
it has the current date, and not the date it is from. If I take the =today()
formula off each page is there any other way to get the date it is from to
print to the pages I want?

Save date to workbook.
 

That works, thanks.
--
Medzzz


"Gord Dibben" wrote:

TODAY() is a volatile function and will change every day.

Copy and paste special as a value.

Or enter a date using CTRL + ;(semi-colon) which will not update tomorrow.


Gord Dibben MS Excel MVP

On Thu, 28 Feb 2008 16:34:00 -0800, CevaClerkII <Joel
Zurba/NA/TNT/TPG@Logistics wrote:

I have a workbook that I copy & paste into a pervious days folder. It has
22 tabs with multiple pages, when ever I go back and print a page that I need
it has the current date, and not the date it is from. If I take the =today()
formula off each page is there any other way to get the date it is from to
print to the pages I want?