Hi,

I wonder if someone can help with a query I have.

I am trying to work out several dates all relative to one fixed date.

So for example I have ‘Date 0’ which is set to, for example, 24 Sep 12, which is a Monday.
Now on either side of this date I have cells with simple maths that show relative dates.
So to the cell left of ‘Date 0’ I have a cell which is “=‘Date 0’-10”. This gives me date 10 days in the past relative to ‘Date 0’. What this doesn’t take into account is the weekends i.e. Saturday and Sunday which are non-working days.

I am looking for a formula/function that would -10 working days as opposed to just 10 days.

I have several cells to the right and to the left of ‘Date 0’ with +/- days to varying degrees.

Can anyone please help with this?
I looked at NETWORKDAY but I didn’t see it as helping.

Many thanks in advance
Frank Leung