Counting occurences of a specific day between two dates

C

coal_miner

Is there a formula that can count the occurences of a specific day between to
dates? I am familiar with an array formula
(=SUM((WEEKDAY(DATE(YEAR(N2),MONTH(N2),ROW(INDIRECT("1:"&DAY(DATE(YEAR(N2),MONTH(N2)+1,0))))))=B4)*1)
that will count the number of times a specific day will be in a month, but I
need for two dates that I set. .My goal is to be figure out how many days a
month employees have worked up to a certain point in the month, but I cannot
use =NETWORKDAYS because we work Saturdays too, but not Sundays. Any help
will be greatly appreciated. Thank you.
 
B

Bob Phillips

=SUMPRODUCT(--(WEEKDAY(DATE(YEAR(N2),MONTH(N2),ROW(INDIRECT(DAY(M1)&":"&DAY(
M2)))))=B4))

where the dates are in M1 and M2

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Expanding Date Formula 0
Search closest day in the past from today 2
count number of dates in a row of cel before or after a variable d 5
Calendar Logic: Recurring Dates 3
Counting text 2
Counting multiple occcurrences between date range 3
Expanding Date formula 2
Date Diff - excluding working days 2

Top