how to calculate days in between dates in straight table? urgent help please

[#1]

Hi,

I have data as below. I need to calculate days between highlighted dates. please can anyone suggest me how to do this?

the condition is when STAGE2 =CC and STAGE2=MR then need to calculate days between DATE 28/01/2015 12:00 and 01/04/2015 18:28                                                                                                 

ID	STAGE1	STAGE2	DATE
43998	CM	AP	18/05/2015 15:32
43998	PD	CM	24/04/2015 14:24
43998	DTD	PD	08/04/2015 14:11
43998	MR	C	08/04/2015 14:10
43998	D	MR	01/04/2015 18:28
43998	DA	D	01/04/2015 18:01
43998	RE	DA	28/03/2015 17:14
43998	RA	RE	28/03/2015 16:38
43998	CP	RA	13/03/2015 16:49
43998	CS	CP	27/02/2015 13:30
43998	QR	CS	27/02/2015 13:29
43998	EL	QR	27/02/2015 13:28
43998	TA	EL	11/02/2015 14:51
43998	CC	TA	11/02/2015 14:51
43998	CC	CC	28/01/2015 13:30
43998	LG	CC	28/01/2015 12:00

Thanks.

[#2]

Please can anyone help

[sunny_talwar]

You want this in a text box object?

[#4]

not in text object. I need in straight table as original file have lots of IDs. would it be possible?

[sunny_talwar]

So against all the same ID rows you want to see one number which would be the difference between STAGE2 =CC and STAGE2=MR?

[#6]

yes exactly. is it possible?

[sunny_talwar]

Looking for this?

[#8]

this is not working.

[Digvijay_Singh]

check this, Not sure though if this is what exactly needed -

[#10]

I have used this. I will check with user regarding data and will get back you. Thanks.