Hopefully someone can help. Been at this for a day already!
I have a range of predetermined dates in columns C and D.
In column E, I have entered a formula to return "Select Period", looking for the date in B2 in the range of dates.
What I would like is that a value is automatically shown in all cells above the one that says "Select Period", in this case cells E4 through E8. Whatever solution you come up with needs to work if the Project Start Date in B2 is changed.
Thank you in advance for your lights!!
Bookmarks