setting up networkdays
 

I need to take a number in A1 (inventory) and divide it by the networkdays
for each month. A1 would represent Jan, B1 Feb...... The formulas would be
in A2, B2.....

Without setting up a table how do I get Networkdays to "work".

setting up networkdays
 

Hi,

Put this in a1 and drag right for 11 cells to get the workdays in each month

=NETWORKDAYS(DATE(YEAR(TODAY()),COLUMN(A1),1),DATE (YEAR(TODAY()),COLUMN(A1)+1,0))

Now i'm not sure what you want to divide a1 by each of these use this and
drag right

=$A$1/NETWORKDAYS(DATE(YEAR(TODAY()),COLUMN(A1),1),DATE( YEAR(TODAY()),COLUMN(A1)+1,0))

Mike

"mp" wrote:

I need to take a number in A1 (inventory) and divide it by the networkdays
for each month. A1 would represent Jan, B1 Feb...... The formulas would be
in A2, B2.....

Without setting up a table how do I get Networkdays to "work".

setting up networkdays
 

Thanks, worked great. One question - if you have column headers with the
month/year showing, can you point the formula to the month shown? I'm
thinking of working a macro in to setup a rolling 12 months.

"Mike H" wrote:

Hi,

Put this in a1 and drag right for 11 cells to get the workdays in each month

=NETWORKDAYS(DATE(YEAR(TODAY()),COLUMN(A1),1),DATE (YEAR(TODAY()),COLUMN(A1)+1,0))

Now i'm not sure what you want to divide a1 by each of these use this and
drag right

=$A$1/NETWORKDAYS(DATE(YEAR(TODAY()),COLUMN(A1),1),DATE( YEAR(TODAY()),COLUMN(A1)+1,0))

Mike

"mp" wrote:

I need to take a number in A1 (inventory) and divide it by the networkdays
for each month. A1 would represent Jan, B1 Feb...... The formulas would be
in A2, B2.....

Without setting up a table how do I get Networkdays to "work".

setting up networkdays
 

Once thanks - I figured out the answer to my second question.

"Mike H" wrote:

Hi,

Put this in a1 and drag right for 11 cells to get the workdays in each month

=NETWORKDAYS(DATE(YEAR(TODAY()),COLUMN(A1),1),DATE (YEAR(TODAY()),COLUMN(A1)+1,0))

Now i'm not sure what you want to divide a1 by each of these use this and
drag right

=$A$1/NETWORKDAYS(DATE(YEAR(TODAY()),COLUMN(A1),1),DATE( YEAR(TODAY()),COLUMN(A1)+1,0))

Mike

"mp" wrote:

I need to take a number in A1 (inventory) and divide it by the networkdays
for each month. A1 would represent Jan, B1 Feb...... The formulas would be
in A2, B2.....

Without setting up a table how do I get Networkdays to "work".