Forum Discussion

Hogstad_Raadgivning's avatar
Hogstad_Raadgivning
Iron Contributor
Dec 22, 2020
Solved

Can Net.workdays.intl spill(#)?

Hi,   Can net workdays intl spill, if start date and enda date is from dynamic arrays, like filter function.   =NETT.WorkdaysINTL(F8#;G8#;1;Datalister!$C$6:$C$17)   Result:   Result #VA...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Dec 26, 2020

    Hogstad_Raadgivning 

    Geir, I'd recommend to avoid INDIRECT() as much as possible. Two reasons

    1) It affects performance which could be not important for relatively small data set

    2) It's not suitable from maintenance point of view. If, for example, one  day you decide to insert another column between F and G, or move the range to the left/right, you shall manually change "G" within INDIRECT() on another column.

    Variant could be, if you have the spill in F8,

    =NETWORKDAYS.INTL(+F8#,+G8:INDEX(G8:G100,ROWS(F8#)))

    as

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 26, 2020

Hogstad_Raadgivning 

Geir, I'd recommend to avoid INDIRECT() as much as possible. Two reasons

1) It affects performance which could be not important for relatively small data set

2) It's not suitable from maintenance point of view. If, for example, one  day you decide to insert another column between F and G, or move the range to the left/right, you shall manually change "G" within INDIRECT() on another column.

Variant could be, if you have the spill in F8,

=NETWORKDAYS.INTL(+F8#,+G8:INDEX(G8:G100,ROWS(F8#)))

as

Resources