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!

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!

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

"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!

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

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