Hi all

I am attempting to use an array formula which I can't get to work.

The column headings are consecutive days of the year and the row
headings are rollout dates.
The array formula I am attempting to use is:

=IF(B$1:GC$1<=$A2:$A793, 0, (NETWORKDAYS($A2:$A793, B$1:GC$1)-1))

I am getting #VALUE! errors where the calendar dates are greater than
the rollout dates.

Thanks in advance

Paul Martin
Melbourne, Australia