98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Date
Date
Resolved · Low Priority · Version 2007
Wed 13 Apr 2011, 13:40Delegate Valentina said...
Valentina has attended:
Excel Intermediate course
Date
when I add a value in a cell (an amount of money for example) is it possible to have the today's date appear in a correspondant cell in another column?
Thanks
Valentina
Wed 13 Apr 2011, 14:05Trainer Anthony said...
RE: Date
Hello Valentina, thanks for your query. There is no way to do this with standard functionality, but a small but of code can be added to the workbook to make this happen:
http://sourcedaddy.com/ms-excel/automatically-add-date-time-cell-upon-entry.html
I will be training with you tomorrow and Friday so I can add this to the relevant workbook for you if you like. Drop by at lunchtime or give me a shout if you spot me
Anthony
Wed 20 Apr 2011: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Using an equal (=) sign that isn't part of a formulaBefore you type the equal sign, type an apostrophe: ' |
