How To Calculate the Number of Fridays between two dates.

  • Thread starter Thread starter Shukla456
  • Start date Start date
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,
 
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.
 
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.
 
Thanks .. Many Many Thanks indeed..!

Thanks to all of you my friend.

Best regards,

Amreshwar
 
Back
Top