Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Date

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Date

Resolved · Low Priority · Version 2007

Reply 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

For upcoming training course dates see: Pricing & availability

Reply 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.

Excel articles

· How To Avoid The Embarrassment Of Dirty Data
· How To Create A Data Table In Excel 2010
· Microsoft Excel can ensure you keep on top of your finances
· Make A Custom Sort List In Excel
· Reporting and Analysis with Excel

Please browse our web site to find out more about
microsoft+excel+training+course and other Microsoft training courses.

Excel tip:

Use Paint Brush to Format More than one Cell

To copy a format to many cells or ranges

1. Select the cell with the format that you want to copy

2. Double-click on the paint brush

When you move to the cell where you want to paste the format you will notice that a paint brush follows the cursor.

Paste the format to all the cells or ranges you need to format.

When finished go back to the paint brush on the tool bar and single click on it to deactivate the function.

View all Excel hints and tips