How do I keep the date from being updated every day

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use the following formula in an Excel worksheet:
=IF(L2=0,"",TODAY())

I would like for it to stay the original date it puts in there. Right now I
have to copy the entries and paste them back as values so it won't change the
date tomorrow when I start the spreadsheet again.
 
I created a simple macro to do this that enters the today() function into the
desired cell then copies and pastes the values of that cell over itself.
Thus pressing the shortcut key (ctrl+shift+d in my case) will enter the date
of today into the desired cell as text which will not change unless you run
the macro again. This is a very simple macro to create using the macro
recorder. If you are new to macros I could walk you through it.
 
Brandt

CRTL + ; will also enter a static today's date in a cell, but this doesn't
help JDP with the TODAY() function in a formula.

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 create an automatic date entry? 10
if/then insert date but don't want automatic updates 7
converting working hours to days 2
how do I get autodate to stay the date it was saved 3
how to calculate hrs flown in last one year 0
Excel High lightng dates in future, today and past 1
Excel How to get the number of days an item was opened from the today's date. 14
today's date static 1

Back
Top