Display the text of Active Months based on a date range
I hope someone can help me here!
I am trying to display a list of active months based on a date range.
https://us.v-cdn.net/6031209/uploads/73YQTGYMLCE7/image.png
The screen shot just shows a manual selection. But since the date entry is automated using a connector, I would like to also automate the Active Project Months to prevent misalignment.
Here is the path I took, but got stuck.
- Find difference in months between start and end: =((YEAR([Project Contract End Date]@row) - YEAR([Project Start Date]@row)) * 12) + MONTH([Project Contract End Date]@row) - MONTH([Project Start Date]@row)
- Determine Start Month and Year: =IF([Project Start Date]@row <> "", IF(MONTH([Project Start Date]@row) = 1, "January", IF(MONTH([Project Start Date]@row) = 2, "February", IF(MONTH([Project Start Date]@row) = 3, "March", IF(MONTH([Project Start Date]@row) = 4, "April", IF(MONTH([Project Start Date]@row) = 5, "May", IF(MONTH([Project Start Date]@row) = 6, "June", IF(MONTH([Project Start Date]@row) = 7, "July", IF(MONTH([Project Start Date]@row) = 8, "August", IF(MONTH([Project Start Date]@row) = 9, "September", IF(MONTH([Project Start Date]@row) = 10, " October", IF(MONTH([Project Start Date]@row) = 11, "November", IF(MONTH([Project Start Date]@row) = 12, "December"))))))))))))) + " " + YEAR([Project Start Date]@row)
https://us.v-cdn.net/6031209/uploads/ABB0VSL48M49/image.png
From here, I was hoping to use a helper sheet that has a list of the Month Year somehow look up the "First Month Year" in that list, then collect the number of cells below it that match the Count of Months. I am stuck on how to do this though. Is it possible, or are there any other clever approaches to this? Thank you!