Calculating three working days before a date

[stevewy]

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?

 

[Guest]

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.

 

[stevewy]

Hmm. Seems I'm going to have to get our I.T. section to install the
Analysis Toolpak before I can use either of these functions. I
wondered why I wasn't getting too far with the Networkdays( )
function!

But thanks for the advice.

Steve

 

[Robert McCurdy]

If your dates start from A2..

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


Regards
Robert McCurdy
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?

 

[Guest]

Did you already look under Tools->Add ins? usuall it is there already.