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".