View Single Post
 
Old 01-09-2017, 05:59 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Reply With Quote