Workdays
Assuming a date (any date within the month) is in cell A1:
=NETWORKDAYS(EOMONTH(A1,-1)+1,EOMONTH(A1,0))
(does not account for holidays in this form; but that could be added if you
have a range including the dates of the holidays - see help on NETWORKDAYS
function for details)
--
- K Dales
"Steph" wrote:
Is there a way to determine the number of workdays in a given month?
|