Nested formula using WORKDAY function

[Guest]

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!

 

[Guest]

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


„davisk†ezt írta:

 

[Ron Rosenfeld]

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

 

[Guest]

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


„davisk†ezt írta:

 

[Guest]

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

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

 

[Ron Rosenfeld]

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