Hi,
I hope someone can help provide a formula to count the number of saturdays for example appears between two dates (see attached).
Thanks.
Hi,
I hope someone can help provide a formula to count the number of saturdays for example appears between two dates (see attached).
Thanks.
Try
=INT((B6-(B5+(7-WEEKDAY(B5))))/7)+1
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Perfect, thank you!
If you're using excel 2010 or later...
=NETWORKDAYS.INTL(B5,B6,"1111101")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks