To find out number of sundays and saturdays in january month

  • Thread starter Thread starter pol
  • Start date Start date
P

pol

Hai all,


How I can find out the number of saturdays and sundays in January

For example in A1 and B1 cell represents Saturdays and Sundays. How I can
find out the number of saturdays and sundays in that month and to write in
corresponsing A2 and B2 column . Please help

with thanks and regards

Pol
 
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(DATE(2008,1,1)&":"&DATE(2008,1,31))),1)=1))
Would tell you the number of Sundays in January of 2008.

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(DATE(2008,1,1)&":"&DATE(2008,1,31))),1)=7))
Would tell you the number of Saturdays in January of 2008.

But I'm not really sure what you have in A1 and B1. Maybe the first and last
date of the month you're interested in?

If that's true, you could use:
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)),1)=1))
and
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)),1)=7))
 
Hai all,


How I can find out the number of saturdays and sundays in January

For example in A1 and B1 cell represents Saturdays and Sundays. How I can
find out the number of saturdays and sundays in that month and to write in
corresponsing A2 and B2 column . Please help

with thanks and regards

Pol
Click to expand...

With some date in the month of interest in C1

A2: Number of Saturdays
=5-(MONTH(36+C1-DAY(C1)-WEEKDAY(C1-DAY(C1)+1))<>MONTH(C1))

B2: Number of Sundays
=5-(MONTH(36+C1-DAY(C1)-WEEKDAY(C1-DAY(C1)+7))<>MONTH(C1))

--ron
 
Back
Top