If your dates start from A2..

=A2-CHOOSE(MOD(A2,7)+1,-4,-5,-4,-5,-3,-3,-3)


Regards
Robert McCurdy
wrote in message ups.com...
I am trying to work out the formula for the above. I know there is
the function NETWORKDAYS(), and upon searching this newsgroup I have
seen messages (one quite recent) for working out the number of working
days between two days. But I need to do it the other way round - give
Excel a date and get it to display another date three working days
before that. It would also be useful if I could put in a list of bank
holidays and other "working day" exceptions somewhere in the sheet and
have the formula take these into account too.

Could anyone point me in the right direction? Is it NETWORKDAYS I
need, or a different formula?