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,

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,

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,

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,

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,

Thanks .. Many Many Thanks indeed..!

Thanks to all of you my friend.

Best regards,

Amreshwar