[Formula Assistance] Date to weekday and sum

[Tosko]

Hi there,

I've been searching the internet for a while and I find examples that I cannot use in my situation.
Please let me explain what I am trying to achieve.



Worksheet1 has thousands of dates in row A:A formatted as (date + time): 28-01-2018 18:55:20, and In worksheet2 I want to sum the dates and split them into weekdays from Monday to Sunday.

So Worksheet2 shows:

A1 = Monday
B1 = (should have a formula which does a check on Worksheet1!A:A and count the monday dates)

A2 = Tuesday
B2 = (should have a formula which does a check on Worksheet1!A:A and count the tuesday dates)

etc. etc.



Could anyone here please help me out figure out the formula? Thanks in advance!

 

[bkjohn2016]

=SUMPRODUCT(--(WEEKDAY(Sheet1!A:A)=2))

Where 1 = Sunday, 2 = Monday...and so on.

 

[Tosko]

Sorry for the delayed response,

Unfortunately I was unable to get it to work. I get #VALUE ! as a result.

Some of the dates:

2014-12-18 8:26
2015-1-5 14:56
2015-2-21 15:00
2015-2-5 15:06
2015-1-12 15:08
2015-2-5 15:11
2015-1-23 7:42
2015-1-28 10:03
2015-1-30 11:00
2015-2-11 15:50
2015-2-12 11:12
2015-2-11 10:23
2015-2-13 10:24
2015-2-16 12:39
2015-2-13 6:58


These are in sheet DATA!A:A

 

[Tosko]

I got the answer

=SUMPRODUCT(--WEEKDAY(Sheet1!A:A;2)=1)),