Calculated column to find the difference between 2 days, exclude sat & sunday and dates from a holiday list RRS feed

  • Question

  • Hi ,

    I'm trying to create a formula that will find the difference between 2 dates, [start date] and [end date] in list 1. however! in addition it needs to exclude the dates from another list, which stores holiday dates.

    =(DATEDIF([Start Date],[Due Date],"D"))-INT(DATEDIF([Start Date],[Due Date],"D")/7)*2-IF((WEEKDAY([Due Date])-WEEKDAY([Start Date]))<0,2,0)+1

    but i'm trying to maybe throw another if in there to exclude the dates found in my holiday list.

    Surendra Singh, MCITP: SharePoint Administrator 2010

    Thursday, February 23, 2012 7:41 AM