Date_Find
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
bsanthoshpk
8 - Asteroid
08-09-2021
02:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
3 REPLIES 3
17 - Castor
08-09-2021
02:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
22 - Nova
08-09-2021
02:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 : )
08-16-2021
03:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thanks for the solution, sorry for the delay reply...i will check and let you know if this meet my requirements 🙂
