Forum Discussion
Convert calendar formula from individual dates to date range & show overlap
Hello! I have modified a calendar template to accomodate my team's projects. The current template we're using only auto-populates the calendar with individual dates, and we're looking to have it s...
IMHO, such logic doesn't work. If, for example, you have two projects P1 and P2 both having the reference ended by _1, they both are to be placed into the first row of the day if start/end day overlapping.
If your Excel support dynamic arrays you may use FILTER function like
=IFERROR(FILTER(Projects!$C:$C,(D4<=Projects!$F:$F)*(D4>=Projects!$E:$E)),"")
assuming each project has start and end dates.