Monthly, Bi-monthly, Quarterly, Yearly Report Tracking Help

Hi all,

I want to create an excel sheet to keep track of all reports done within a year while setting prompts when some of the reports are due/nearly due. I understand basic excel functions/conditional formatting and have been googling around for answers and am reaching the dead end of my thought processes.

Attached is the workbook detailing the purpose and description of what I want to do with my excel spreadsheet.

Any help or tips in the right direction for formulas to use are greatly welcomed. I won't mind doing further formula research if required.

Currently using Excel 2013.