I have the following formula:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
=IF(NETWORKDAYS(NOW(),G110)<1,1,IF(NETWORKDAYS(NOW(),G110)<=3,2,""))
<o> </o>
I need this in vb form where if the result of the first test is <1, I will add to a counter else if the result of the second test is <=3 I would add to another counter.
<o> </o>
Any help would be great….
<o> </o>
Many Thanks!!
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
=IF(NETWORKDAYS(NOW(),G110)<1,1,IF(NETWORKDAYS(NOW(),G110)<=3,2,""))
<o> </o>
I need this in vb form where if the result of the first test is <1, I will add to a counter else if the result of the second test is <=3 I would add to another counter.
<o> </o>
Any help would be great….
<o> </o>
Many Thanks!!