networkdays with if statement

[tdrose01]

Hi,

i trying to get this =IF(TODAY()-Q6>T6,T6,IF(TODAY()-Q6<0,0,TODAY()-Q6)) to work with networkdays?

I've tried this with no good results =IF(NETWORKDAYS(Q6,TODAY(),holiday!B20:B33)<0,0,NETWORKDAYS(Q6,TODAY(),holiday!B1:B14))

I'm trying to get how many days are completed but do not want to see negative numbers. any ideas or help would be appreciated.

Thanks,

[Ron Coderre]

Not sure why you've got 2 holiday ranges.
Maybe this...(using just 1 holiday range)

Please Login or Register  to view this content.

Is that something you can work with?