Though i have never used it personally before now, look into the WORKDAY
formula, got it to work for your scenario like this
=WORKDAY(C1,-3)
date in C1 formula in B1, may return serial number, format it as date.
There is a 3rd option you can look into with holidays as well.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


" wrote:

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?