View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Count the Number of Workdays

One way...

A1 = start date
B1 = end date

=SUM(INT((WEEKDAY(A1-{1,2,3,4},2)+B1-A1)/7))

--
Biff
Microsoft Excel MVP


"Rocetman" wrote in message
...
Trying to figure how I can take a start and end date and count the number
of
work days based on a Monday through Thursday work schedule. Does
NetWorkdays
function have a special operative that will enable me to perform the above
condition.