Thread: Workdays
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K Dales[_2_] K Dales[_2_] is offline
external usenet poster
 
Posts: 1,163
Default 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?