• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Attendance Sheet

I

Iftikhar

New Member
Dear Chandoo,
Need your kind help to fix my problem in the attached attendance sheet. As per our office necessity I need D/O (Day off) is to be type instead of "P" in the cell on any day of the week because we have employees some of who are having weekend on different days instead of Sunday's. I have tried but it is reducing number of days in "P" column of total attendance which I don't want it. I will appreciate your help.
 

Attachments

Not sure what exactly you need. But I understood it as you need "D/O" as well as "P" counted in column AI.
=COUNTIF(D7:AH7,"*"&AI$6&"*")+COUNTIF(D7:AH7,"*D/O*")
 
You must log in or register to reply here.
Back
Top