Originally Posted by steve.

Hi

I know that there are threads on thsi site trying to deal with thsi issue, and till now i am still unable to get it to work. I have been told locally that it can't bedone, but readind various threads simular to what i am tryin gto do i think there is a solution.
This is what i am trying to do( i am no excel boffin by any means so please keep it simple)
Cells A = invoice no
Cells B = location
Cells C = Payment amount due (£)
Cells D = Invoice sent out (Y/N)
Cells E = Invoice Paid in (amount £0.00)
Cells F = Date Paid

So what i am trying to sort out is when i enter the data into Cell E i want the date to automatically placed / auto enter into Cell F. This have done by using the following formula:
=IF(E280,NOW()," "). but by using this formula it changes every time when i load the spread sheet on a different date
i.e.
entered the amount in Cell E, say on the 20th May 2011 it then automatically entres the date of that day using the formula as above, and saved it the sheet.

Reopen it again say on the 25th May 2011 the date changes from the 20th to the 25th, which is not what i want. All i want is for the date to remain the same as when i entered the amaount in Cells E on the 20th, this then shows me the date of when it was either entered or paid.

Please can anybody advise me on how to sort this out.

Look forward to your assistance.

Please keep it simple (idiots guide would great!!)