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