Hi Experts,

I have an excel like below,

Name Status Dates

Record 1 /Saved/Previous step/My Q/ Rework/ MY Q/ SAved/ Next step /01.03.2015/05.03.2015/07.03.2015/09.03.2015/11.03.2015/15.03.2015/25.03.2015
Record 2 /Previous step/My Q/SAved/ Next ste /02.03.2015/05.03.2015/09.03.2015/22.03.2015
Record 3 /Previous step/My Q/ Rework/ MY Q/ SAved/ Next step /05.03.2015/08.03.2015/12.03.2015/19.03.2015/22.03.2015/25.03.2015

I want to know when the record has reached my q and when it has moved out of the q and How many days it took before moving out of the q in the fourth column. Sometime the record will have reworks, when the record come back to our Q and will be moved out after validation.

Name Status Date

Record 1 My Q 07.03.2015
Record 1 Rework 09.03.2015
Record 1 My Q 11.03.2015
Record 1 Next step 25.03.2015

or
Name Entry Status Moved out status Arrival to my q date Completed (days)

Name Status Moved to status Date Completed in(days)
Record 1 My Q Rework 07.03.2015 2
Record 1 My Q Next step 11.03.2015 14

Regards,
Bala