Count Weekdays
Count remaining weekdays in a month
Enter as Date
=INT((DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)-DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(A1)))/7+1)
It will give the number of remaining weekdays (eg Saturday) of the date you choose for the current month, including the date entered in A1. Adjust to suit.
A1 = Date
Enter as Day of the Month
Enter Day as in "1" (or any other day of the month you like) into cell A1
In another cell enter this formula.
=INT((DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)-DATE(YEAR(TODAY()),MONTH(TODAY()),A1))/7+1)
It will give the number of remaining weekdays (eg Saturday) of the day you choose for the current month, including the day entered in A1. Adjust to suit.
Count between 2 Dates
John Mansfield of The Planning Deskbook kindly let me use this formula. http://pdbook.com/index.php/
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)),1)=C1))
A1= Start Date, B1 = End Date, C1 = Weekday (Sunday = 1. Adjust this number to work with other weekdays such as Monday = 2, Tuesday = 3 etc)
This is a formula I thought up
=IF(C1<=WEEKDAY(B1),INT(((B1-(WEEKDAY(B1)-C1)+7)-A1)/7),INT((B1-(WEEKDAY(B1)-C1)-A1)/7))
A1= Start Date, B1 = End Date, C1 = Weekday (Sunday = 1. Adjust this number to work with other weekdays such as Monday = 2, Tuesday = 3 etc)