How do I had working days only to a particular cell value ?

[cstandinguk]

Hi there,

I am having real trouble figuring this one out.

I have a date in a cell that I want to add 15 days onto and display in a seperate cell, and do the same for 40 days. Trouble is, it has to be working days only.

Can anyone offer any advice ?

Thanks in advance

Chris

[BigBas]

Try using the NETWORKDAYS formula. Hopefully this link will help.

http://office.microsoft.com/en-us/ex...091901033.aspx

[daddylonglegs]

In fact, to add a number of working days to a date, you need NETWORKDAYS cousin, WORKDAY. Both these functions require Analysis ToolPak to be enabled (Tools > add-ins > tick "analysis toolpak"), e.g. to add 15 workdays to a date in A1

=WORKDAY(A1,15)

You can also exclude holidays by adding a third argument, e.g.

=WORKDAY(A1,15,holidays)

where holidays is a named range containing a list of holiday dates