Hi Excel Experts,

We have a database of attendance report, however, considering multiple in & out we require data base in desired format.

Into attached file there are 2 different worksheets i.e. 1. Available database & 2. Desired worksheet

From Available database, we are require fields in following manner in summarized way..

PERSONNUM | In | Out | Report date from | Report date To | No. of Shifts attended (in between to & from dates) | Details
(I have prepared manual workout into Desired worksheet, however, column F and G is difficult calculate manually hence, only 1 record is calculated)
For Example..
From To No. of Shifts attended (in between to & from dates)
21-Feb-2018 13-Mar-2018 19 (Calculated dates in between these two dates, those are only finding in Available database)

Please help me to resolve the issue.

Kravindra