Find start & end date in timesheet

[rr1050]

Hello there,

I have attached excel file.

For example, I have kept only two months Jan and Feb in a separate sheet. But actually, it will be in fact Jan to Dec separate sheets in the future.
When person present at work then written P and A for absent. However person name is same on all sheet, but maybe reference is not same.
In example, name ABC in Jan 18 row 3 & Feb 18 row 4.

My requirement Result sheet, in this it says Person details when he is present or absent with finding the first date and end date .

Thanks ,

Rahul

[jindon]

You need to change the date in 'FEB 18'!B1 to any day in Feb, currently 2018/1/18.

Please Login or Register  to view this content.

[rr1050]

This works entirely perfect.
Many Many thanks and your valuable time.