The SPC has obvious practical application to the captive insurance and reinsurance industries as it allows insured persons to better assess and handle the risks of the insurer by focusing only on the sufficiency of reserves of the relevant segregated
To insert a fixed date into a cell (a date that you don't want to change) hold down Ctrl while you press the semicolon ( ;) key. To insert the current time (without a date), press Ctrl-Shift-Semicolon.
That function will update when any cell it references change, so you won't have to tie it into any events. After having put that code into a module in your workbook, you can simply input =Updating_Date(B5) into C5 and then copy it down. That should make the date in C5 update whenever the values in column C changes. In order to make the date only appear if the cell in column B isn't blank, you could apply an if-formula in the cell in column C, as I touched on in the other question you asked.