Adding working days

[George Gee]

Hi All

I wish to add Working days to a date:

I have the formula:
=IF(D3="","",A3+(F3/10)+7)

A3 is a date, I wish to add (F3/10)+7 working days to A3,
how do I rewrite the formula?

Thanks in advance.

 

[JE McGimpsey]

If you load the Analysis Toolpak Add-in (Tools/Addins...):

=IF(D3="","",WORKDAY(A3,F3/10+7))

 

[George Gee]

JE McGimpsey

Thanks for the response.
However I an unable to load the Analysis Toolpak Add-in!
I get an error, saying the feature is not installed, and do I wish to
install it.
When I click "Yes", I get an error listing various things that do not seem
to apply
to me!

Also, this spreadsheet will be used from a server, so if all users need the
Analysis Toolpak Add-in, then it may be as well not to bother, as this is
beyond my
control.

Will have to think of another way for the time being.

Thanks again.

George



*JE McGimpsey* has posted this message: