Date_Find

Question

Hi All,

I need help for attached file.

Below is my logic requirement that I am trying to solve but couldn’t.Consider A007 and let’s take today we are in 11th (Wednesday)… that cell is empty. Now all I need to find is previous YES and post coming YES. So here in this case previous Yes is Monday. Upcoming Yes is Thursday. The logic should find this and populate date of previous YES in completed cadence and post coming Yes in Next cadence. Thanks!

Date_Find.xlsx

bsanthoshpk · Answer

@JosephSerpis @atcodedog05

thanks for the solution, sorry for the delay reply...i will check and let you know if this meet my requirements 🙂

atcodedog05 · Answer

Hi @bsanthoshpk

Here is how you can do it. I am confused if Wednesday is Yes is it considered in completed and next candence

Workflow:

If this doesn't meet your requirememt please provide expected output.

Hope this helps : )

Cadence.yxmd

JosephSerpis · Answer

Hi @bsanthoshpk I mocked up an approach let me know what you think?

Date_Find_09082021.yxmd