# of Fridays in a month

M

mtkatrev

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

Peo Sjoblom

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
 
D

Daniel.M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to get number of days excluding Fridays in a given period 17
Calculating the number of Fridays in a month 5
How to list dates in a month of particular weekday 9
Counting a day of the week 3
How To Calculate the Number of Fridays between two dates. 5
Excel Dates 3
1st Monday of a month in date range?? 22
count work days excluding Fridays and Saturdays ??? 3

Top