amend the formula not to update each day

[seansr]

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(),"")

 

[tomas]

Hi

Today is function which put current date in a cell. so erase this and reference the date of posting

 

[seansr]

So how can I change the formula to put in the date in once and once only

 

[tomas]

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

 

[Deepak]

@ seansr

What tomas said is

=IF(ISBLANK(E28)=FALSE,A28,"")

Where A28 is the cell where u manually inserting the date.

 

[Deepak]

& Your should be like as

=IF(ISBLANK(E28),"",A28)

 

[seansr]

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)

 

[Deepak]

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!!