1. Where you type in January, enter it as the date e.g. 1/1/17. Format it to display as the you like. The format for full month is "MMMM". Then use formulas to put the dates into your table. You can get creative to have it suppress invalid dates such as February 30.
2. and 3. Use Cell/worksheet protection.
|