Hi,
I need your help with the formula to get no of working days in a month by an employee based on the "In" & "Out" tagging
In Row 1 I have the header , In , Out, In, Out, In Out, In Out ( repeated 4 times , since an employee can take leave 4 time a month and come back)
Eg, employee Number 1, came to office on 1 March 2016 which shows under "in" & the date is showing 28th Mar 2016 unders Out which means he was in office for 28 days, & again "in" date shows 30th march which means, he came back to office on 30th match and Out date shows 15 April, which means 1 days comes in March and 14 day comes in April
I know my question may not be that clear, you might understand when you see a sample file that is attached.
can someone help me to get this by formula?
thanks for your help
Regards
Arvind
Bookmarks