Greetings all,
I'm looking for a faster formula to accomplish what is accomplished in the range J4:Z8 of the attached spreadsheet - it checks whether the above month falls within a range of dates in the area C4:H8, and then assigns the cell a value based on an IF formula.
The actual sheet I'm working in includes 200 components, each part of 7 distinct phases that occur over a period of 4 years, split up by week. Thus, the actual function is a series of 7 nested IF functions, and the formula itself is present in over 90,000 cells - as you can imagine, the computing process is quite slow, and any change made to the other sheet columns results in a long wait while each of these calendar rows is recalculated. I'm looking for something that more quickly checks where the date in Row 3 falls with respect to columns C:H, and returns a value based on that check.
Thanks!
Bookmarks