Count Saturdays in a List
You can modify it to work with the 1904 date system. I don't suspect that a
lot of people on PC's use that? And maybe not even that many on the Mac.
=SUM(IF(MOD(R,7)=1,1))
--
Cheers,
Shane Devenshire
"daddylonglegs" wrote:
I think that
=SUM(IF(MOD(R,7),,1))
is a little dangerous, Shane. If you're using the 1904 date system it'll
count Fridays.......
"ShaneDevenshire" wrote:
And one mo
=SUM(IF(MOD(R,7),,1))
Array entered. Where R is a range name for your data.
--
Thanks,
Shane Devenshire
"T. Valko" wrote:
=SUMPRODUCT(--(WEEKDAY(A1:A20)6))
Biff
"H" wrote in message
...
Hi,
I need to count the number of Saturdays in an array of dates. I used the
following approach, which didn't work. Does anyone have another idea?
{=SUM(IF((WEEKDAY(array1,2)=7),1,0))}
Thanks!
|