Calculate Due Date Based on 2 options

(0) Share

Report

Posted on by MarlaynaJack

I have a Project Tracker list in Sharepoint. It has the following fields

Item Name
Initial Call Date (Date field)
Was There a Delay? (Choice field, yes or no)
Day Started Due to Delay (date field)
Due Date (date field)

I also have a list called Federal Holidays, where I have listed all of the federal holidays by date.

I want to do the following, and no matter how many ways I try, it doesn't work. Definitely a PICNIC issue, and it's time for me to get help so I can move on.

1. Check to see if there was a delay
2. If no, calculate due date 14 business days (so excluding holidays and weekends) from the initial call date. For example, if the call date was on July 1st, the due date should be July 21st because there was a holiday and 6 Weekend Days to account for.
3. If yes, calculate 14 business days from the Date Started Due to Delay