Ignore hidden cellls networksdays and Lookup

[excelnabb]

Hi

I have a formula to count the number of weekdays between two dates, however, when I change the last date by filter, ex excluding the last month, it still takes into account the hidden cells, how do I change the lookup to exlude hidden cells such that it only takes the last visible cell into the caclulation?
=NETWORKDAYS(B15,(LOOKUP(2,1/(B:B<>""),B:B)))

[FlameRetired]

I would need a sample workbook representative of what you are working with and the outcome(s) you want.

Please see instructions in the 'gold' banner at the top of the page. HOW TO ATTACH YOUR SAMPLE WORKBOOK:

[GeoffW283]

Pending the workbook as requested by Dave, here's a guess:

filters.png

In D15 copied down: No formula, just the numeral 1

In E15 copied down:
=AGGREGATE(9,5, D15:D15)
This evaluates to 1 if the row is visible and zero if the row is hidden

In F15 copied down, just y or n to allow filtering.

In B13:
=NETWORKDAYS(B15,(LOOKUP(2,1/((B15:B25<>"")*E15:E25),B15:B25)))
Here I have simply added E15:E25 to your formula which gives zeros for hidden columns.

In the above image with no filters applied the workdays are 7
Filtering out the "Y"s the number of visible workdays in B13 will be 5 which I think is what you are expecting.

I'm not sure this is the answer you are looking for and even if it is I suspect there are simpler ways!

See the attached workbook.

Let us know if this is anywhere close.