need help to lookup a (workday) date, and then excel output to show that date minus 1

Hi,

I'm trying to built a report that contains a visit schedule for our technical people.
Although i have the dates available when they will be visiting the client, I need to pull the date of when the equipment that is needed for the visit in another column.
Our rule is to have the equipment available on this site 1 working day before the visiting date.
Currently this is done manually, but I think this can also be done by some type of formula.

So.....
A1 contains the visit date
B1 should contain the latest delivery date of the goods needed for the visit
(both are working days)


Is there a formula that can do this?

Sounds like I'm suffering from a typical Friday end-of-business problem ;-)
should have know it was that easy, thansk for pointing it out Miraun!