You're not even trying to understand and amend these formulae to suit your workbook, are you? You can't simply paste a formula into a different structure of workbook, make NO changes to it, and complain it doesn't work...

Why not try to understand HOW my formula worked, then TRY modifying it to suit your actual workbook. THEN post if you are still struggling. Right now, you're not learning, you're just getting us to do your work for you...

You also need to make clearer your specification of what you are trying to achieve. I can't see where the "Strength | Present | Leave | LOP" column headers affect your outcome? And the "More than 3 days" requirement is unclear.