Have you tried pivoting your data so you have 3 columns - the first is project, the second is phase and the third is start date -
you will find it much easier to do your data check
Thanks for the quick response. I'm not sure I follow, but the "phases" is what I need to define, based on date ranges and the given projects.
Yes I understand but your data is not well structured to do that -
Pivoting the data will put it into a structure where you can compare date in a single column to your check data and determine which phase you are in rather than trying to create a complicated series of if statement to check a series of separate dimensions
see the link below on how to pivot