TODAY () - START DATE = X. but if CELL ROW = "Yes", stop the counter and take the value. If cell = "No" continue date formula

[TTUK]

Hi All,

As the subject suggests...
TODAY () - START DATE = X. but if CELL ROW = "Yes", stop the counter and take the value. If cell = "No" continue date formula

G2 = TODAY()
The START DATE is in column F9:F100
The count between TODAY() and the START DATE is shown in columns K9:K100
If columns Q7:Q100 has the value 'YES' I need the valuve which is in the count of RANGE K9:100 to be displayed in the approiate row in column L9:L100.

If columns Q7:Q100 has the value 'NO' then I need the it = VALUE in column K9:K100

Please, please, please can someone help me with this?!

Thank you!!

 

[oldbrewer]

not clear yet, friend, imho....

make a dummy sheet with 10 rows and ask again....