Forum Discussion
Difference between dates in columns with multiple values
Hello there, helpful people, I might need your brain power regarding a few calculations that at first I thought it made sense theoretically, but in practice I can't wrap my head around it. B...
Hi LuciferMstar ,
I am confused about your calculation logic. I can see two dates in Status 2 for ID 153. Should both dates in Status 2 larger than both dates in Status 1 for each ID or just need one meet your logic?
Please show me the result you want and share a sample file with me. This will make me easier to find the solution.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.