Working date calculator

Good Afternoon All,

I've been pulling my hair out over a calculator I've been asked to create.

Various formulas needed for different dates have my head in a spin.

The result in H16 must be 3 calendar Months previous to the start date in H3
The result in H20 must be 15 working days in advance of H3.
The result in H23 must be 10 working days previous of H3.
The result in H26 must be 15 working days in advance of H3.
The result in H29 must be 10 working days previous of H20.



All calculated dates must be working days. Any date which lands on a Saturday, Sunday or bank holiday, must show the PREVIOUS working day as the result.

I have a list of weekends and bank holidays stored on sheet2 a1:a564.

Any help would be most appreciated.

Noel.

Edit: I'm using Microsoft Excel 2007.