Working Day Formula

  • Thread starter Thread starter housinglad
  • Start date Start date
H

housinglad

Hi

I am after a formula to clauclate working days?

For example if the date which i have in cell B2: what code/formula would I
use to determine one working day from that date for cell C2?

Hope that makes sense, basically I want to clauclate 1 working day from the
date entered in a cell.

Mnay thanks
 
Hi,

try this formatted as date

=WORKDAY(B2,1)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
That is very good thanks, however the code messes up if there if no value in
B2, is there q piece of code so that if there is a date then add one workday
if the cell is blank then do nothing?

Hope that makes sense.

Is the workday formula incoperated within MS EXCEL 2003??
 
There is a "WORKDAY" function that will allow you to accomplish this task.
In Excel 2003 you need to make sure the Analysis Tool Pak is installed in
order for this to work.
 
Hi his fomula works fine in excel 2007 however does not work in 2003, i need
the code for excel 2003.

Please help
 
Read excel's help for =workday() and you'll see that xl2003 and before have to
have the analysis toolpak addin loaded.

Help describes how to do this, too.
 
Back
Top