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,