How to count all entries for each day for this week

davital

I am trying to find a logical function for count rows that were added on sunday, monday...friday

on this week only(and refresh it to the next one).

can you please help me?

thank you!

davital

the function I typed:

=COUNTIFS({Gym Check-In per Day}, {Gym Check-In per Day} = 1, {Gym Check-In per Date}, WEEKNUMBER({Gym Check-In per Date}) = WEEKNUMBER(TODAY()))

I want to count all the entries that were on sunday and in this week(in addition want to refresh the week after it will end)