View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default NETWORKDAYS? Maybe not?

=H3/NETWORKDAYS(DATE(YEAR(B1),MONTH(B1),1),DATE(YEAR(B 1),MONTH(B1)+1,0))
--
David Biddulph

"Ken" wrote in message
...
Excel2003 ...

Cell B1 contains a manually input Date (1st day of month (mm/dd/yy)) & I
change it as the Months change.

I need to divide a number (Cell H3) by the # of NET WORKDAYS in the month
displayed in Cell B1.

Thanks ... Kha