Nested formula using WORKDAY function
 

I have a formula that I am using to project dates. Cell equals another cell
plus 3 (formated as dates). i.e In cell F4 formula is =F3+3
But if that date falls on a date other than a "workday", I need it to
automatically change to the next available workday (Mon thru Friday only) and
eliminate the weekend date. Right now I am having to use 2 different
cells/formula to find the correct date. In another cell I use:
=WORKDAY(WORKDAY(F3),-1),1) to determine if the result in F4 is a "Workday".
Is it possible to combine the formulas into one? Using an "IF" or "AND" type
of nested formula?

THXN!

Nested formula using WORKDAY function
 

Try =WORKDAY(F3,3) in F4 and drag it down as necessary!
Regards,
Stefi


€ždavisk€� ezt Ã*rta:

I have a formula that I am using to project dates. Cell equals another cell
plus 3 (formated as dates). i.e In cell F4 formula is =F3+3
But if that date falls on a date other than a "workday", I need it to
automatically change to the next available workday (Mon thru Friday only) and
eliminate the weekend date. Right now I am having to use 2 different
cells/formula to find the correct date. In another cell I use:
=WORKDAY(WORKDAY(F3),-1),1) to determine if the result in F4 is a "Workday".
Is it possible to combine the formulas into one? Using an "IF" or "AND" type
of nested formula?

THXN!

Nested formula using WORKDAY function
 

On Fri, 19 Oct 2007 05:08:00 -0700, davisk
wrote:

I have a formula that I am using to project dates. Cell equals another cell
plus 3 (formated as dates). i.e In cell F4 formula is =F3+3
But if that date falls on a date other than a "workday", I need it to
automatically change to the next available workday (Mon thru Friday only) and
eliminate the weekend date. Right now I am having to use 2 different
cells/formula to find the correct date. In another cell I use:
=WORKDAY(WORKDAY(F3),-1),1) to determine if the result in F4 is a "Workday".
Is it possible to combine the formulas into one? Using an "IF" or "AND" type
of nested formula?

THXN!

If I understand you correctly, the three days you are adding could be
non-workdays, so long as the result is not a workday. In other words,
Wednesday, Thursday, or Friday should all give the subsequent Monday.

If that is the case, then:

=WORKDAY(F3+2,1,[holidays])

(Note that the holiday list is optional).

should work.

If you want to add three workdays, then just use

=WORKDAY(F3,3,[holidays])


--ron

Nested formula using WORKDAY function
 

"Stefi" wrote:

Try =WORKDAY(F3,3) in F4 and drag it down as necessary!
Regards,
Stefi


€ždavisk€� ezt Ã*rta:

I have a formula that I am using to project dates. Cell equals another cell
plus 3 (formated as dates). i.e In cell F4 formula is =F3+3
But if that date falls on a date other than a "workday", I need it to
automatically change to the next available workday (Mon thru Friday only) and
eliminate the weekend date. Right now I am having to use 2 different
cells/formula to find the correct date. In another cell I use:
=WORKDAY(WORKDAY(F3),-1),1) to determine if the result in F4 is a "Workday".
Is it possible to combine the formulas into one? Using an "IF" or "AND" type
of nested formula?

THXN!

Nested formula using WORKDAY function
 

Ron, yes exactly but though the formula make perfect sense to me; I can't get
it to work:-( operator error?

"Ron Rosenfeld" wrote:

On Fri, 19 Oct 2007 05:08:00 -0700, davisk
wrote:

I have a formula that I am using to project dates. Cell equals another cell
plus 3 (formated as dates). i.e In cell F4 formula is =F3+3
But if that date falls on a date other than a "workday", I need it to
automatically change to the next available workday (Mon thru Friday only) and
eliminate the weekend date. Right now I am having to use 2 different
cells/formula to find the correct date. In another cell I use:
=WORKDAY(WORKDAY(F3),-1),1) to determine if the result in F4 is a "Workday".
Is it possible to combine the formulas into one? Using an "IF" or "AND" type
of nested formula?

THXN!

If I understand you correctly, the three days you are adding could be
non-workdays, so long as the result is not a workday. In other words,
Wednesday, Thursday, or Friday should all give the subsequent Monday.

If that is the case, then:

=WORKDAY(F3+2,1,[holidays])

(Note that the holiday list is optional).

should work.

If you want to add three workdays, then just use

=WORKDAY(F3,3,[holidays])


--ron

Nested formula using WORKDAY function
 

On Fri, 19 Oct 2007 06:19:02 -0700, davisk
wrote:

Ron, yes exactly but though the formula make perfect sense to me; I can't get
it to work:-( operator error?

You'll need to supply more information.

"can't get it to work" is not specific enough to enable trouble shooting.
--ron