I need a function that returns the workdays in any given month/year.
Bonus if it also excludes holidays.
Thanks,
Art
I need a function that returns the workdays in any given month/year.
Bonus if it also excludes holidays.
Thanks,
Art
Given Year in A1, Month(number) in B1
C1:C20 = list of holiday dates you create to be excluded from the count.
=NETWORKDAYS(DATE(A1,B1,1),DATE(A1,B1+1,0),C1:C20)
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)
Bookmarks