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.
In Cell A1, you can put your starting date. Then, in cell A2, put the formula =A1+7. Then, just click and drag down cell A2 as far as you need. If you want to change the starting date, just change the date in cell A1. Again, the other way to do this would be as jonsca mentioned, by using Excel's smart auto fill feature. It detects the difference between two cells and auto-increments it using the drag-to-fill-down feature.