This is to do with dates. In short, there is an admin allocating dates to every user. When planning something for a particular user, I want to check if there is someone else who can be grouped with this user - i.e. if another user has an allocated date that is 15 days before or after our considered user.
I have reached until here:
With some dancing around I am setting the base date for the batch calculation. -That’s my first column seen here. If the row doesn’t belong to the considered (baseline user) then I subtract or add 15 days from their date (which serves as baseline date) and populate the +/- 15 for all users (2nd and 4th column). The calculated dates are then shown in the 3rd and 5th columns, where 3rd = 1st plus 2nd, 5th = 3rd+4th column.
I want to create a conditional math column where I can say if calculated date is less than (ie earlier) allocated date by admin then “no” the user isn’t a batch mate, else “yes” the user is a possible batch mate.
Logically … straightforward. Executing it here though…haha, it’s got me stumped! All the IF conditions are non mathematical - how do I set a ‘if lesser than X then Y’ condition? I can’t use excel because these columns have to be user specific columns in my functionality - multiple people could be planning for the users, so each of them should see ‘relative’ batch filtering based on the user that they chose.
Can someone please point me in the right direction to explore/help me solve this? TYSM!