How To Calculate the Number of Fridays between two dates.

S

Shukla456

Can any body tell me how to calculate the number of Fridays between two dates
( say 1 Jan 10 to 15 June 10)?

Is there is a way to do this in excel ?

Thanks in advance..

Best Regards,
 
B

Bob Phillips

Try

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(--"2010-01-01"&":"&--"2010-06-15")))=6))
 
M

Mike H

Hi,

Like this. The 6 equals Friday, other days of the week are in the table.

=INT((WEEKDAY(A1-6)-A1+A2)/7)

1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
G

Gary''s Student

With dates in A1 and A2:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)),2)=5))
 
J

JLatham

You may have noticed that Mike and Bob tested against a value of 6, while
Gary''s Student tested against a value of 5. It's same thing, but Gary
forced the WEEKDAY() function to cause Monday to = 1, instead of Monday = 2
as Mike and Bob setup for. See Excel's Help topic for WEEKDAY for more
information about this.
 
S

Shukla456

Thanks .. Many Many Thanks indeed..!

Thanks to all of you my friend.

Best regards,

Amreshwar
 

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

How to Create an S-Curve from Custom Field? 0
how can we calculate the numbers of hours between two dates and 4
number of months and days between two dates without approximation 3
Finding the proper style field and the numbered paragraph value within the style 0
Creating a Search using a combo box and then creating a report. 4
Send meeting request for different dates (no repetition) to different people 0
Finding the right style field in VBA 0
calculation of future value between two dates 2

Top