The Missing Values Pattern

I have a list of Projects, each of them have a Start Date. Each month a Project Report is due for all running Projects (Project Start Date < Period EoM).   Business wants to track Projects not hav...