• 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.

amend the formula not to update each day

seansr

Member
I have the spreadsheet with the following formula that works fine, however today I notice it has changed the date from yesterdays date to todays date. But it should be the date of posting not keep updating. I am sure there is a simple change but not sure what that should be

=IF(ISBLANK(E28)=FALSE,TODAY(),"")
 
Hi

Today is function which put current date in a cell. so erase this and reference the date of posting
 
So either you have the date you want to put in other cell then you need to reference the adress of this cell. If you don't have then you have to write the date as an argument in your function and in correct format.

If you have a problem with that I recommend you to post here a sample file
 
Please see copy of File
What I want is if a reference number is added in to column E then add the current date into Column H
But never update the Date in H once added ( This is the date of Posting)
 

Attachments

  • EBAY SALES.xlsx
    45.8 KB · Views: 0
Please see copy of File
What I want is if a reference number is added in to column E then add the current date into Column H
But never update the Date in H once added ( This is the date of Posting)


I doesn't think that this would be possible without VBA!!
 
Back
Top