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.
I can use the TODAY formula to automatically insert today's date, which can then be updated... but I'm trying to create a log with minimal entries. What I want to do is associate the date cell with a log notes cell such that when the a specific note cell is edited, the date cell updates as well...