Save date to workbook.

C

CevaClerkII

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?
 
G

Gord Dibben

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
 
C

CevaClerkII

That works, thanks.
--
Medzzz


Gord Dibben said:
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
Click to expand...
 
Top