Save date to workbook.

  • Thread starter Thread starter CevaClerkII
  • Start date Start date
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?
 
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
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 page break changes when forwarding workbooks 1
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Printing Workbooks 3
Excel Formula - Count Dates from another Sheet 8
print with displying date 5
Printing Excel workbook 6
Macro to create a Weekly Workbook 4
Expanding Date formula 1

Back
Top