workday function

[Kalabalana]

hey, any help at all would be appreciated,
I need a worksheet function that finds the date 20 work days from th
current date.
please help, I could not find any excel integrated worksheet function
for workdays

Edit: I've found the worksheet function, sorry to waste your tim

 

[Frank Kabel]

Hi
try
=WORKDAY(A1,20)

Note: you must install the Analysis Toolpak Add-in for this

 

[Kalabalana]

if I install the analysis tool pack on my machine, and create a shee
using one or more of it's functions, namely a template, will th
function still, err umm function, without having the analysis toolpac
installed on their machine

 

[Frank Kabel]

Hi
no: they also have to install this Add-in

 

[Kalabalana]

if that's the case, is there a worksheet function (without using an
toolpacks) that can add 20 work days to a date, and return the ne
date?
i'm sure the excel gurus would love to chomp down on this on

 

[Kalabalana]

what if I were to take the vba code from the analysis pack, an
incorporate it into the spreadsheet? that was anyone access the shee
would be able to use the function right

 

[Frank Kabel]

Hi
you can't take the code from the ATP. Here's an alternative function to
use for this case.
Assumptions:
A1: starting date
B1: number of workdays to add
C1: Formula:
=B1+INT((B1+MOD(A1-2-(MOD(A1,7)<2)*(MOD(A1,7)+1),7))/5)*2+A1-(MOD(A1,7)
<2)*(MOD(A1,7)+1)

Probably could be shortened