nested IF and Workday function

Hi I posted this earlier but didn't include my formula so apologies!


I’m trying to design a worksheet that automatically updates and populates dependent on certain conditions being met.

I have a list of students in Colum B

These students will be assigned a Stage in Colum C.

They will be allocated on a date (to a Teacher) in Colum D.

I’m trying to calculate a field in Colum E (Expected Completion Date) and I would like that to be 20 working days from the allocation date in Colum D unless the stage is equal to PSR when it should be 15 working days.

I’ve tried using the workday function in a nested IF formula but can’t seem to get it to work, could somebody help at all as I can’t really move on until the first formula works. The formula is in cell E2 & references B21:B29 to holidays

Thanks in advance for any advice/help

Continue in the original thread: https://www.excelguru.ca/forums/showthread.php?9166-Help-with-formulas&p=37660

You can add extra detail there and even change the title if you wish, Don't open duplcate threads!!!