Weekly Data per Person Counter

[nearph]

Hi Everyone,

I want some help on my weekly tracker per Person, so if a person A appears in column A with 8 entries in week 1 (Monday - Sunday), how can I create a excel formula to track person A entries per week in a week of (4).

I have attached some excel sample, I hope I was able to explain it correctly.


Regards,

[davsth]

perhaps if you put the 1 in j1, 2 in k1 etc

=SUMPRODUCT(($A$3:$A$41 >=DATE(2019,12,21+J$1*7))*($A$3:$A$41< DATE(2019,12,28+J$1*7))*($B$3:$B$41=$I3))

it would have been helpful for you to provide your expected answers

[Kaper]

sorry, somehow answer to other thread was published here :-(

[nearph]

perhaps if you put the 1 in j1, 2 in k1 etc

=SUMPRODUCT(($A$3:$A$41 >=DATE(2019,12,21+J$1*7))*($A$3:$A$41< DATE(2019,12,28+J$1*7))*($B$3:$B$41=$I3))

it would have been helpful for you to provide your expected answers

Hi Darth, thank you for you reply..

I think my expected results would be:

January first week: "how many entries created by this 'person'".

2nd week and so forth..

Programing approach explanation:

if 'Person' added an entry in 'specific dates in a week,

then Show (person entries in first week, 2nd week, etc.)