How To Calculate the Number of Fridays between two dates.
 

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,

How To Calculate the Number of Fridays between two dates.
 

Try

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

--

HTH

Bob

"Shukla456" wrote in message
...
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,

How To Calculate the Number of Fridays between two dates.
 

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.


"Shukla456" wrote:

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,

How To Calculate the Number of Fridays between two dates.
 

With dates in A1 and A2:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)),2)=5))
--
Gary''s Student - gsnu201001


"Shukla456" wrote:

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,

How To Calculate the Number of Fridays between two dates.
 

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.


"Shukla456" wrote:

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,

How To Calculate the Number of Fridays between two dates.
 

Thanks .. Many Many Thanks indeed..!

Thanks to all of you my friend.

Best regards,

Amreshwar