NETWORKDAYS question

[halesowenmum]

I have a spreadsheet where cells A3:A10 contain bank holiday dates which I've given the Name 'BH'. They are in a sheet called 'Bookable dates'.

In the same sheet in B3 (for example) I want to display a date which, taking =TODAY() which resides in cell W1, calculate the following, and be able to fill the formula down.

Taking today's date at 181 days to that date and display the date output by that (which is representative of a weekly meeting which takes place every Monday except for UK Bank Holiday dates taken from the Named region 'BH').

How do I do that please?

 

[halesowenmum]

That should say:

Taking today's date add 181 days...