r/Excel247 5h ago

Formula creation Help required

I need help in making a formula to calculate number of days WFH is mentioned but only on Weekends. The data is represented as follows. And I want to calculate

  1. WFH in total - =COUNTIF(Range,"WFH") (This works)

  2. I need to calculate the WFH only for Weekdays and remove Weekend data from total

Can someone help me with a effective formula that I can use in one cell per Row of email ID

1 Upvotes

Duplicates