Time and date stamp

Resolved · Low Priority · Version Standard

Time and date stamp

Anthony has attended:
Excel Advanced course

by - delegate Anthony [5 posts] (2008 Mar 27 Thu, 08:05) Reply

Hi

Was wondering if you would be able to help me with a formula.

I have a worksheet that is filled in by users as they input invoices.

In Cell A8 i have written the following formula:

If(B8="","",NOW())

The idea is that if the user types an invoice number into B8 it will record the time and date they entered the record. This formula works for the first record but after i copy the formula down through column A if something is entered into B9 it will update A9 as also A8 which will distort the figures. Is there any way to stop this from happening?

Hope this makes sense, if not please let me know.

Many thanks

Tony

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Time and date stamp

by - delegate Anthony [5 posts] (2008 Mar 27 Thu, 08:17) Reply

Apologies i think that i may have just figured it out by adding another condition to the IF formula. The formula now reads:

=IF(B8="","",IF(A8="",NOW(),A8))

and this appears to have done the trick.

Thanks anyway

Regards

Tony

· A Beginners Guide To Formulas In Excel
· Tools From Advanced Excel Courses: Goal Seek and Solver
· Why Should I Learn Visual Basic in Excel?
· How Small Businesses Profit from Outside Excel Training
· Training Budgets In A Bad Economy

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

Excel tip:

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

View all Excel hints and tips