ExcelBanter - NETWORKDAYS? Maybe not?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - NETWORKDAYS? Maybe not? (https://www.excelbanter.com/excel-discussion-misc-queries/181523-networkdays-maybe-not.html)

Ken

NETWORKDAYS? Maybe not?

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

David Biddulph[_2_]

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

Ken

NETWORKDAYS? Maybe not?

David ... Works great ... I do not use date formulas much ... And I never
think about adding the +1 to get the end date ...

Thanks for supporting the boards ... Kha

"David Biddulph" wrote:

=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

All times are GMT +1. The time now is 09:03 PM.