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

Today's date in Excel - keep the date?
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....


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".
Reply: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.
Reply:In Excel, click on the Help Tab and read all about using Dates.





Works every time!!!

dentures