Todays Date that does not update

  • Thread starter Thread starter Tom Meacham
  • Start date Start date
T

Tom Meacham

I created a macro and a button that when clicked it entered todays date in a
cell, which is what I wanted. I used "Today( )".
Problem is the date keeps updating to todays date and I want it to stay the
date I entered it in. Is there some other value or formula to do this so it
does not update everyday?
Thanks!!
 
You need to enter the date itself. Any function will always
update to the current date. Ctrl+; will enter the current date in
a cell.

In VBA, use

Range("A1").Value = Date



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
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

Pivot table macro filter data between yesterday and today (date+time) 0
PLEASE HELP! need conditional formatting related to date, blank cellsand today's date 16
today 6
Conditional formating 4
Date that does not update 5
Excel Message box with days of month & date. 1
Update: Date 1
Complicated Date Calculation needed 5

Back
Top