Thanks for getting back to me so quickly! I was begining to think that a formula was not going to do this for me.
You are correct that when a code is entered in column A a date stamp will be entered in the same row in column C. In answer to question 2 first, the formula is based on A>1 as the cell in column A is blank and I do not want a date entry in the row unless values for the full row are being entered (ie a stock in/out entry)
The value entered in column A should never change (unless an entry error has been made - the whole row would be removed), but even if a correction was to be made, I would want the original date stamp to remain valid.
I appreciate that the TODAY() function is a volatile one but was hoping beyond hope that there was another function or formula available that would easily do the job for me without having to get into a VB macro.
Just to throw something else into the mix... I already have a VB macro in the worksheet for the controlling of the stock in/out entries using pop-up boxes and a barcode scanner but don't see this having any major complications for trying to solve my date issues.
Whilst I have managed to sort out the data entry macro, my programming skills are seriously limited hence my plea for help on the date stamp!
Any and all help you can give me would be very much appreciated!