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)



© Copyright andrewsexceltips.net All Rights Reserved.