COUNTIF and weekdays

[Shinano]

I have a range A1:A31 listing the weekdays of a month. I need to count weekdays in this range in one cell and weekend days in another cell.

I am trying to come up with a formular using COUNTIF, but for some reason I can not get it right.

Any advice is appreciated.

 

[MarkAndrews]

Multiple countif's

=countif(a:a, "Monday")

=countif(a:a, "Tuesday")etc

 

[barry houdini]

If A1:A31 contain dates then you can count weekdays with

=SUMPRODUCT(--(WEEKDAY(A1:A31,2)<6),--(A1:A31<>""))

and the weekends with

=SUMPRODUCT(--(WEEKDAY(A1:A31,2)>=6),--(A1:A31<>""))

 

[Joe4]

Barry,

Is the European version of Excel different than the US version? On our version, the Weekday function returns 1 for Sunday and 7 for Saturday, so the formulas you posted would need some tweaking to work.


EDIT: Barry pointed out to me the second argument of the WEEKDAY fucnion, which accounts for this.

 

[Shinano]

Thank you for the swift reply. I really appreciate it.

On more question, Barry. What are the: -- ?

I am sorry, but it has been some time since I have used Excel and my skills are pretty rusty.

Again, thanks a lot.

 

[Domenic]

Have a look here...

Hope this helps!