• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Automatically fill a cell just once

S

swensor

New Member
I am making an invoice sheet which will include historical as well as current purchases.


I auto-populate the date field with the current date when a new item is entered with =IF(F3<>"",TODAY(),""), where cell F3 is a cell for a new item name.


My problem is that when I open the sheet to add a new item several days later, all of the previously filled cells in the F column are not null, so all of my date cells are changed to TODAY().


How can I populate the date field with the date the new item is entered, and not change it the next time the worksheet is opened. Thanks.
 
Check out Chandoo's guide here:

http://chandoo.org/wp/2009/01/08/timestamps-excel-formula-help/


If that won't work, we could try using visual basic to add the time stamp. Your choice as to which method you want to use.
 
You must log in or register to reply here.
Back
Top