Problem linking dates and missing weekends (newbie alert)

I've done a couple of searches and found a couple of similar items... unfortunately none have culminated in a resolution.

I have a date which i'm trying to link dates to the future and past. As the links grow and the number of dates vary I need the automated dates to miss the weekends. I cannot seem to get this to work.

A simple example would be: My "locked" date would be 11/09/2013 (4th Sept 2013 - UK date format) - Lets assume this in Cell C1.
Now i'd like to allow 3 days either side of this. These need to be work days (Mon to Fri), therefore for the past date (in Cell B1) rather than giving me a date of 08/09/2013 (Sun) I need to ignore the weekend and jump to the 06/09/2013 (Fri) For the future date (in Cell D1) I need the formulated date of 16/09/2013 (Mon) and not 14/09/2013 (Sat)

In addition will I be able to us the same Formula principle when I expand these dates further into Cells A1 and E1 and beyond? (A1 would be formulated from the value in B1 and E1 would be formulated by the value in D1)


I confess that I am a proper Excel amateur. I'm hoping that this is reasonably easy to sort? Therefore I'm looking for a Formula that I can copy, paste and amend appropriately (I assume the formulas will be different when working the dates both forward and backwards?)

PBA- There would be no point trying to explain it to me as you'd loose me into cross-eyed world pretty quickly.

Thanks in advance guys and gals,

WH_14