Working Day Formula

[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

 

[Mike H]

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.

 

[housinglad]

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??

 

[MichaelVB]

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.

 

[PJ]

This works for me in excel2003;

=IF(B2="","",WORKDAY(B2,1))

 

[housinglad]

Hi his fomula works fine in excel 2007 however does not work in 2003, i need
the code for excel 2003.

Please help

 

[housinglad]

.... ANYONE??

Hi his fomula works fine in excel 2007 however does not work in 2003, i need
the code for excel 2003.

Please help

 

[Dave Peterson]

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.