How can I lock a date that has been established by the 'today ()'.

  • Thread starter Thread starter Guest
  • Start date Start date
Copy>Paste Special>Values>OK>Esc.

OR enter the date using CRTL + ;(semi-colon)

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

How do I do a TODAY() Function within a Nested IF AND Function 1
Show todays date if ticked 2
If cell is blank automatically enter today's date in the same cell 21
Pivot table macro filter data between yesterday and today (date+time) 0
Lock in date 1
Record-Locking remains open after closing 0
How to records that the date field = todays date in VBA 2
Excel How to get the number of days an item was opened from the today's date. 14

Back
Top