# of Fridays in a month

  • Thread starter Thread starter mtkatrev
  • Start date Start date
M

mtkatrev

Is there any way to calculate how many Fridays (paydays)
there are in any given month?
Excel 2003
 
One way

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&DATE(YEAR(A1),MONTH(A1)+1,0))),2)
=5))

where A1 would hold the first date of the month, e.g. is you put 05/01/04 in
A1 it will return

4
 
Hello,

Assuming the year (2004) in A1 and the month (1=> Jan, ..., 12 => Dec) in A2:

The number of Fridays:
=4+(DAY(DATE(A1,A2,35))<WEEKDAY(DATE(A1,A2,2)))

Assuming ANY date of a month in A1, number of Fridays of same month is:
=4+(DAY(A1-DAY(A1)+35)<WEEKDAY(A1-DAY(A1)-5))

Assuming the date in A1 is always the first of the month (as in Peo's example):
=4+(DAY(A1+34)<WEEKDAY(A1-6))

Regards,

Daniel M.
 
Back
Top