Hello,

I have a question in regards to collecting data over a period of time on specific dates.

I have an A-column with dates in this format:

2/18/2019
2/15/2019
2/14/2019
2/13/2019
2/12/2019
2/11/2019

Etc...

and I have a % value in in a B-column linked to each day.

I want to count up-days vs down-days for each day of the week from 01/01/2015 and up until now.
One cell for up day Mondays, and one for downday Mondays.
Same for Tuesday, Wednesday, Thursday and Friday.

Could someone get me started? I can not post pictures or tables in the forum for reason so I hope it made sense.

Thank you