Hello I would like to have column where the difference (in days) is calculated between each End date for each ID is calculated.
Here a example of sample data ( this just an example , how to do it o it can work for various case)
ID | End date |
1 | 01/02/2022 |
1 | 01/01/2022 |
2 | 18/01/2022 |
3 | 20/02/2022 |
4 | 19/01/2022 |
4 | 07/01/2022 |
4 | 03/03/2022 |
1 | 18/03/2022 |
2 | 07/01/2022 |
3 | 15/01/2022 |
Here a example of result I want to have
ID | nb DAYS | End Date |
1 | 0 | 01/01/2022 |
1 | 31 | 01/02/2022 |
1 | 47 | 18/03/2022 |
Thanks :)
Solved! Go to Solution.
Hey @Tommy23,
You can use a multi row formula to achieve this:
Any questions or issues please ask :)
HTH!
Ira
No worries @Tommy23, I'm having a look at your question now 😃 Also if you find an answer to your question make sure to give it a green tick.
Hello , Do you ave any Idea why I do not have the same result as you? is it because I am located in France and it is because of the time zone @IraWatt
I'm not sure but it looks like the EndDate_Formatted was sorted descending when it should be sorted ascending? Any ideas @binuacs ?