Code Required to calculate number of days worked, normal overtime and holiday overtime

[nelsondavid]

Dear Alan,

Yes i actually forget to tell you about the absent days.What i mean "Every month we consider of 30 days , if the month is of 30 or 31 or like 28 days Feb all these months we take it as 30 days only.
Total no. of days is the no. of days the person worked plus the holidays(holiday is deducted if the person does not come the day before and after the holiday)

Header row not required

Have attached sample files and the code am using now

thanks,

Nelson