Calculate No of Working days between two specific days excluding weekends

Have a look at the NetWorkDays() function.

Assuming input date is in A2, you can try something like:

="Aging " &LOOKUP(NETWORKDAYS(A2,TODAY()),{1,11,21,31},{"1 to 10","11 to 20","21 to 30","over 30"})

where the first set of parameters in { } brackets represent the lower bounds of each date range and the second set of parameters are the respective return messages.

I know this was 2 years old but if you haven't got a solution and you would still like one then I have one for you. Let me know.
Regards

It is a week old ... :stare:

Ooops! my mistake. :0ops:
Quite new to Forum activity anywhere.
Will compose my possible solution and post shortly.
Regards
legin52

OK first step is to create a table of weekend dates (and or Holidays).
somewhere possibly on a new sheet which can be hidden later if required, in cell A1 (for example) Type in the date 01/01/2018 in B1 type in the day on which your chosen date fell in 2018 it was a Monday then by highlighting the 2 cells and grabbing the autofill cross and dragging down to a date you want, say 31/12/2018. This will give you a calendar. now apply a filter for Monday through Friday to be visible then delete them. This will leave you a list of all the dates for all the Saturdays and Sundays through the period.
At this point I would make use of the name manager to use in the later formula.
This has the added benefit of you being able to add specific bank holidays such as Easter and Christmas (by doing it manually if required.
Now I am going to send the sheet I created so you can see the formula and my construction might be of help.

Hope it helps
Regards
legin52 [ATTACH]n1204944[/ATTACH]