Date in excel

[mo2783]

I have a worksheet which contains data of all invoices sent out and amount sent to customers.

I am trying to automate by adding a column which will show the date the invoices was sent. I have the following if statement in the cell

=if(isNumber(s4),today(),"")

so every time i load the workbook the dates get updated to the current date. using above formula. any ideas how i can store the date so it wont update everyday but will show the date the invoice was sent?

Mo

 

[SkipVought]

Hi,

What is the event associated with sending an invoice?

Short answer is, there is not a spreadsheet function that will do what you want.

Long answer is, record a macro to COPY the date cell and Edit > Paste Special - VALUES. Run the macro in the EVENT that is associated with sending an invoice.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}