Hi,

Anybody have any idea how to find the following:

I want to work out the date based on a number of days but excluding the weekends.

So sat the number is 10 days - this is 10 days since an event.

Working back from - 2/11/18.
This would be the 19th Oct - excluding weekends.

Date Day Days
02-Nov fri
01-Nov thu 1
31-Oct wed 2
30-Oct tue 3
29-Oct mon 4
28-Oct sun
27-Oct sat
26-Oct fri 5
25-Oct thu 6
24-Oct wed 7
23-Oct tue 8
22-Oct mon 9
21-Oct sun
20-Oct sat
19-Oct fri 10

Terry