Hello,
I have to generate a WEEKDAY End Date based on two conditions: "Start Date" and "Internal_External".
SO, if the "Start Date" column is not empty and the "Internal_External" column = "Internal", the calc column, which I am calling the "End Date" must add X number of WEEKDAYS (to exclude weekends) to
the "Start Date".
For example, for the "End Date" calc column:
=IF(AND(WEEKDAY([Start Date]>3, [Internal_External]="Internal",[Start Date]+5,IF(AND(WEEKDAY([Start Date]>1,[Internal_External]="Internal",[Start Date]+3)))
I can't seem to get this to work. HOWEVER, if I enter this formula, with only one condition, it works fine:
=IF(WEEKDAY([Start Date]>3,[Start Date]+5,IF(WEEKDAY([Start Date]>1,[Start Date]+3))
The problem is that I need the formula to calculate the WEEKDAY (exclude weekends) based on two columns: Start Date and Internal_External.
Can anyone assist? I've searched around for the answer but no one seems to need to find the WEEKDAY based on two conditions, at least, none that I can make work.
JSKI
JackSki123