How do I run an Excel function only once?

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

Guest

What I want to do is have Excel calculate the current date a user is updating
a spreadsheet and show that date in a cell. They would then be able to come
back the next day, enter information, and a cell would display the current
date again, while still displaying the date that the spreadsheet was last
updated the previous day.

Basically, I can use the NOW or TODAY functions to calculate the current
date, but I can't get them to run only once then die after it was run.

I will try to look back here for answers but if you have an answer, if you
also wouldn't mind cutting and pasting your resonse in an email to
(e-mail address removed). Thanks very much.
 
a very simple way of date stamping is ctrl+; and for time ctrl+shift+:
or with a macro
range("b22")=date
 
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

I am trying to use the IF and SUMIF function on Excel 8
Trailing 30 days sum calculation with excel 1
Dates in Excel 2007 5
How do a set the current date to change in cell everyday 1
Creating an update query that uses multiple parameters 2
How do I do a TODAY() Function within a Nested IF AND Function 1
I want to change the cell format (color) based on a calc 4
How can i calculate only once? 3

Back
Top