Work out dates between one column on multi rows

[Casi]

Hi,

I have a table 'audit' containing all the different stages of an appeal. I need to work out the dates between the date the status was changed but I am struggling without a start date.

Can anyone please help.

[Casi]

Sorry try this https://drive.google.com/file/d/1xC-qEDk-I9xXZre0HAb9Hz_YK5MsEwif/view?usp=sharing 

[Casi]

Hi,

This is the output i would like:

ceox_auditlogid	ceox_incidentid	ceox_newvalue	ceox_oldvalue	Incident.title	Date Notified
042b04cf-80bf-ed11-83fd-002248c70152	cb53f708-25ad-ed11-83ff-0022481b5e4e	Open Ready	Pending Information	1482728	10/03/2023 00:00
042b04cf-80bf-ed11-83fd-002248c70152	cb53f708-25ad-ed11-83ff-0022481b5e4e	Open Ready	Pending Information	1482728	11/03/2023 00:00
042b04cf-80bf-ed11-83fd-002248c70152	cb53f708-25ad-ed11-83ff-0022481b5e4e	Open Ready	Pending Information	1482728	12/03/2023 00:00
042b04cf-80bf-ed11-83fd-002248c70152	cb53f708-25ad-ed11-83ff-0022481b5e4e	Open Ready	Pending Information	1482728	13/03/2023 00:00
042b04cf-80bf-ed11-83fd-002248c70152	cb53f708-25ad-ed11-83ff-0022481b5e4e	Open Ready	Pending Information	1482728	14/03/2023 00:00
042b04cf-80bf-ed11-83fd-002248c70152	cb53f708-25ad-ed11-83ff-0022481b5e4e	Open Ready	Pending Information	1482728	15/03/2023 00:00
042b04cf-80bf-ed11-83fd-002248c70152	cb53f708-25ad-ed11-83ff-0022481b5e4e	Open Ready	Pending Information	1482728	16/03/2023 00:00
042b04cf-80bf-ed11-83fd-002248c70152	cb53f708-25ad-ed11-83ff-0022481b5e4e	Open Ready	Pending Information	1482728	17/03/2023 00:00
042b04cf-80bf-ed11-83fd-002248c70152	cb53f708-25ad-ed11-83ff-0022481b5e4e	Open Ready	Pending Information	1482728	18/03/2023 00:00
042b04cf-80bf-ed11-83fd-002248c70152	cb53f708-25ad-ed11-83ff-0022481b5e4e	Open Ready	Pending Information	1482728	19/03/2023 00:00
042b04cf-80bf-ed11-83fd-002248c70152	cb53f708-25ad-ed11-83ff-0022481b5e4e	Open Ready	Pending Information	1482728	20/03/2023 00:00
042b04cf-80bf-ed11-83fd-002248c70152	cb53f708-25ad-ed11-83ff-0022481b5e4e	Open Ready	Pending Information	1482728	21/03/2023 00:00
042b04cf-80bf-ed11-83fd-002248c70152	cb53f708-25ad-ed11-83ff-0022481b5e4e	Open Ready	Pending Information	1482728	22/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	22/02/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	23/02/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	24/02/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	25/02/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	26/02/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	27/02/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	28/02/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	01/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	02/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	03/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	04/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	05/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	06/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	07/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	08/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	09/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	10/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	11/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	12/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	13/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	14/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	15/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	16/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	17/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	18/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	19/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	20/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	21/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	22/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	23/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	24/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	25/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	26/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	27/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	28/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	29/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	30/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	31/03/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	01/04/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	02/04/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	03/04/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	04/04/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	05/04/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	06/04/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	07/04/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	08/04/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	09/04/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	10/04/2023 00:00
0610c234-a0b2-ed11-83ff-6045bd0b12c1	cb53f708-25ad-ed11-83ff-0022481b5e4e	Pending Information	Awaiting Validation	1482728	11/04/2023 00:00
1b72fab5-4522-ee11-9966-002248c87a56	cb53f708-25ad-ed11-83ff-0022481b5e4e	Dismissed	Notified	1482728	12/04/2023 00:00
02f496eb-4cbe-ed11-83fe-0022481b9548	666e9176-f5d7-4cf2-9067-d446b5aff3b8	Listed	Notified	14597698	09/03/2023 00:00
02f496eb-4cbe-ed11-83fe-0022481b9548	666e9176-f5d7-4cf2-9067-d446b5aff3b8	Listed	Notified	14597698	10/03/2023 00:00
02f496eb-4cbe-ed11-83fe-0022481b9548	666e9176-f5d7-4cf2-9067-d446b5aff3b8	Listed	Notified	14597698	11/03/2023 00:00
02f496eb-4cbe-ed11-83fe-0022481b9548	666e9176-f5d7-4cf2-9067-d446b5aff3b8	Listed	Notified	14597698	12/03/2023 00:00
02f496eb-4cbe-ed11-83fe-0022481b9548	666e9176-f5d7-4cf2-9067-d446b5aff3b8	Listed	Notified	14597698	13/03/2023 00:00
02f496eb-4cbe-ed11-83fe-0022481b9548	666e9176-f5d7-4cf2-9067-d446b5aff3b8	Listed	Notified	14597698	14/03/2023 00:00
1c965d4f-4ebe-ed11-83fe-0022481b9dcf	666e9176-f5d7-4cf2-9067-d446b5aff3b8	Notified	Listed	14597698	15/03/2023 00:00

[p45cal]

Can you show how you expect the output to be?

Ideally, attach a simple workbook with just these data (perhaps with a few more incidentids)