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.
=NOW(). This function returns both the current date and time. To change the display to show just the date, follow the steps for the =TODAY() function above. To change the display to show just the time: 1  Click on in the menus to bring up the Format Cells dialog box. 2  Click on the Number tab.TODAY(). This function returns the current date. To display the date in a different format than the default: 1  Click on in the menus to bring up the Format Cells dialog box. 2  Click on the Number tab. 3  Select Date in the Category window.