is it possible to remove non-working week days from a day count?

Hello,

If for example between 01/03/2015 and 01/02/2015 there are 28 day, of those 28 days, 20 are working day and 8 are non-working days

Working days being Monday to Friday and Weekend days being Saturday to Sunday.

How is this worked out as a formula?

Regards,

Dangoo

I'm not really sure if it works or not, what I am trying to do is a continuation of the solution I received from this post but eliminating the non-working days: http://www.excelforum.com/excel-form...ml#post3975663

The formula given was =IF(E2<=0,"",IF(COUNT(J2),J2-E2,IF(COUNT(I2),I2-E2,IF(COUNT(H2),TODAY()-E2,0))))

is there a way of integrating your suggestion into the above formula?

Regards,

Originally Posted by Ron Coderre

Using the workbook you posted at the referenced thread...
it seems like this formula, copied down, would work for you

Please Login or Register  to view this content.

Does it?

Unfortunately, it hasn't worked exactly how as planned, but I think if something was added to say if the H column was filled in but the I and J column wasn't then original date minus "real time today's date" (without the non-working week days) it would be spot on. or something along those lines.

I am just wondering if anyone has managed to solve this yet?