time and date stamp

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Time and date stamp

Time and date stamp

resolvedResolved · Low Priority · Version Standard

Anthony has attended:
Excel Advanced course

Time and date stamp

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

RE: Time and date stamp

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

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Formst Excel to display leading zeroes

Select the cells that you want to have displaying leading zeroes.

From the 'Format' menu select 'Cells' (Or Right-click on the selected range and and select 'Format Cells').

In the 'Number' tab click on 'Custom' in the 'Category' window.

In the 'Type:' box enter zeroes that correspond to the size of the required number (eg 5 zeroes).

Click OK.

When you enter numbers into these cells, leading zeroes will be displayed.

eg 123 = 00123

View all Excel hints and tips


Server loaded in 0.08 secs.