Check the validity of Logic Problem #1 in Excel–Part 1

The Task

Create a table in Excel that matches the table in Logic Problem #1 then create a formula (or formulas) to test the validity. Our first validity check will make sure that we have 6 different months and that they are in the correct order. I would also recommend using data validation to ensure that all months entered match the requirements of the logic problem.

Notes

I personally prefer to use a local installation of Microsoft Excel. Microsoft has a free web-based version at http://office.com/WebAppsThinks
Google also has a free web-based spreadsheet that can be found at https://drive.google.com/
 

Feel Free to Comment

I do not provide space to those who visit my blog. If you would like to share any files, you are going to have to find your own online storage. At that point, you can provide links with your comments. I would like to point out that macros can create security risks. If possible, save all documents as a standard workbook (not macro-enabled) unless macros are vital to your solution. If you are going to download any solutions, make sure that you are not loading macros by default. If a spreadsheet includes macros, check the code before running them.  

Related Exercises

Logic Problem #1

Follow-up

A follow-up to this exercise has been posted.