Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Today's date in Excel - keep the date?
I'd like to have today's date automaticly entered in a cell when you add a line(that I know how) but I'd like that date to stay what it was at the time of entry.
Basicly we're creating a list for our sales people where they have to log their job and we'd like to know when they've entered it (date and time) without them entering it (so that they can't cheat.
Thank you
3 Answers
- Sarah MLv 51 decade agoFavorite Answer
To do this, you'd need to use VB/macros.
Here's a link that might explain one approach to this:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=...
description: Add date or time to a cell when a row (or column) is updated.
However, no amount of code is going to stop your sales people from saying "there was a typo, so I fixed it today, but I really entered it yesterday".
- ELfaGeekLv 71 decade ago
In Excel, click on the Help Tab and read all about using Dates.
Works every time!!!
- 1 decade ago
Use a combo of the "now" and "if" function. For example, could use
=IF(B9="","",NOW())
That way if data is entered in B9, the current date will appear.
