I have a spreadsheet which shows the stock of our toners (sample below):
For column F (Date Deplenished) i have a formula, for when the stock reaches "0" todays date will be inserted. Formula is:
=IF(D6=0,TODAY(), " ")
I added the above formula yesterday so the date originally read "10/14/2015". However upon opening the spreadsheet this morning, I've noticed that the date has changed to todays date of "10/15/2015".
This is not going to work, as the date needs to be set to the date when the stock reached "0" and stay that way until I increase it in the "Current Stock" in column D.
Can someone advise how I can accomplish this?