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.
This formula results in the date 9/15/09. You can specify the value of the start date either by referring to a cell that contains a date value or by entering a date enclosed in quotation marks, such as 2/15/10. For example, suppose you want to add 16 months to October 16, 2009. In cell A5, type 10/16/09. In cell B5, type =EDATE(A5,16).