How do you add 40 working days to a date

E

EmmaLaw22

I need a formula to add 40 working days to an existing date field in Excel
for Windows 2000? Can anyone help please???
 
D

Dave Peterson

Take a look at =workday() in excel's help.

You'll have to have the analysis toolpak loaded (tools|addins).
 
K

Kevin B

Look at the help information on WORKDAYS, which will add 40 working days
between dates and has the ability to incorporated holidays as well.

This formula returns a serial date number.
 
Top