LinkBack URL
About LinkBacks
One way...
A2 = the 1st of the month date for the month/year of interest. For example, 8/1/2013
B2:B15 = list of holiday dates to be excluded from the count
Enter this formula in C2:
=NETWORKDAYS(A2,EOMONTH(A2,0),B2:B15)
One way...
A2 = the 1st of the month date for the month/year of interest. For example, 8/1/2013
B2:B15 = list of holiday dates to be excluded from the count
Enter this formula in C2:
=NETWORKDAYS(A2,EOMONTH(A2,0),B2:B15)
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)
Posting Permissions
Register To Reply
Bookmarks