Including networkdays in a formula

[rhk001]

Hi Guys,

I have a formula I use to spread a $ value [L3] between 2 specified dates [H3 & I3]
The problem is the spread should only be for working days and not weekends.

My thoughts are that my formula should include =networkdays but I cannot work out how to include it, could someone help me out or let me know if I am barking up the wrongtree and should be using something else to achive the result.


=IF(AND(N$2>=$H3,N$2<=$I3),$L3,"0")

Thanks in advance Rob

 

[rhk001]

All sorted all it needed was *

=IF(NETWORKDAYS(M$2,M$2)*AND(M$2>=$G3,M$2<=$H3),$K3,"0")