Formula for present, absent & extra credit (Time Sheet)

[Vivek2705]

Hii Require Formula in cell D2 for the Following situation.

1st criteria: For sunday or Second saturday : If hours worked is blank then present else extra.

2nd criteria: For other days (Mon to sat excluding 2nd sat): If hours worked is blank then Absent else Present.

Attached here is the sheet for your reference & formula.

Thanks.

[Bo_Ry]

Please try at D2

=IF(OR(WEEKDAY(A2)=1,A2=WORKDAY.INTL(EOMONTH(A2,-1),2,"1111101")),IF(C2="","Present","Extra"),IF(C2="","Absent","Present"))

If not correct, please provide manual expect result.

PS. day in column B is wrong.

[Vivek2705]

Perfect!! Thanks a lot...