workday function

  • Thread starter Thread starter Kalabalana
  • Start date Start date
K

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
 
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
 
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
 
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
 
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
 
Back
Top