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.


"housinglad" wrote:

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

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

"Mike H" wrote:

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" wrote:

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

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.

"housinglad" wrote:

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

=IF(B2="","",WORKDAY(B2,1))
Russell Dawson
Excel student


"housinglad" wrote:

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

This works for me in excel2003;

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

"housinglad" wrote:

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

"Mike H" wrote:

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" wrote:

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 his fomula works fine in excel 2007 however does not work in 2003, i need
the code for excel 2003.

Please help

"Russell Dawson" wrote:

=IF(B2="","",WORKDAY(B2,1))
Russell Dawson
Excel student


"housinglad" wrote:

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

.... ANYONE??
"housinglad" wrote:

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

Please help

"Russell Dawson" wrote:

=IF(B2="","",WORKDAY(B2,1))
Russell Dawson
Excel student


"housinglad" wrote:

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

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.

housinglad wrote:

... ANYONE??
"housinglad" wrote:

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

Please help

"Russell Dawson" wrote:

=IF(B2="","",WORKDAY(B2,1))
Russell Dawson
Excel student


"housinglad" wrote:

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

--

Dave Peterson