COUNTIF with a certain word in a week

NickJonesLG

Hi All,

A client wants to be able to see how many calls were logged in thier current working week . However the working week begins on a Friday 00:00am and ends Thursday 11:59pm.

I'm after a formula to count all entries with the word "Aberdeen" in the Column called "Club" in the mentioned working week . This counter would then be reset when the new working week begins

I have the Count formula : =COUNTIFS(Club:Club, CONTAINS("Aberdeen", @cell))

I just need to include the Working Week range to the formaula .

Thankyou

NickJonesLG

So need to add something to this formula : =COUNTIFS(Club:Club, CONTAINS("Aberdeen", @cell))

which only searches for any "Aberdeen"s that were this working working week and then resets when the new working week begins ( Friday 00:00am )