I’m hoping you can help me with some suggestions
In the attached sheet, there is a formula copied down in column S that looks at various criteria across columns K, N and O. It looks to see if there is a date in column K, then if a date is present in columns N and O before returning the desired result (ie. the BG reference)
What I need in this formula is also (as well as the above) to include the criteria stating if the date in column T (or K however I was getting a circular reference) is greater than the current day’s date, then its OK to still show the BG reference. If the date is less than today’s date, then the respective cell in Column S will return a blank.
I tried modifying the formula is column S to read but am getting a circular reference error :-
For example, I have highlighted the items in question, in Column V, in orange. For example , row 5, cells S5 to Y5 would be blank as the date is less than today’s date. As all these cells bounce off a value being present in Column S, they would automatically be empty if the formula in S5 contained the ‘date’ if then criteria.
Any help would be greatly appreciated