I appreciate your time and effort.

I would like to have formula for column O and P.

Column A : lots of Asset

Column C: date

If one Asset is used more than 5 consecutive days than that date range (Start date and end date) should go to column 0 and no of consecutive days go to Column P.

I try no of different formula

Column E : =IF(C4-C3=1,C4-C3+E3,1)

Column F: =IF(E4+1=E5, "In used","End")

Column G: =IF(A4=A5,IF(C4-C3=1,C4-C3+G3,1),C4-C3+G3)

Column H: =IF(A4<>A3,"START OUTTER",IF(A4=A5,"Used","Outer End"))

How can I copy Column C and (E or G) to column O and P base on my condition.

Also would like to update status as "consider as day use- if no of days used less than 5 days -and this total no need to copy Column Q.

Thanks,