Set deadline date as 10th day of every month excluding weekends RRS feed

  • Question

  • I would need to set up a deadline date in a SharePoint list to calculate 10th day of every month excluding weekends.

    Ex: If 10th day of any month is a weekend (Saturday), it needs to set the 10th day as the previous business day(Friday).

    I am looking for a SharePoint calculated field to achieve this, Thanks in advance!

    Friday, March 20, 2015 4:25 PM


  • You'll have to build it in pieces - will take a bit of experimentation but 

    First build the date of the 10th.

    Date(year, month, 10) - not sure what your date field you are building off off, but if you built it off of the created date it would look something like 

    Date(Year([Created]), Month([Created]), 10)

    Then you'd have to test to see if that was a weekend, and subtract 1 day if it was a Saturday, or 2 if it was a sunday.

    I haven't tested this, but something along these lines. weekday 6 is Saturday, weekday 0 is sunday

    Where I have an X, replace that with  Date(Year([Created]), Month([Created]), 10)

    =IF(WEEKDAY(X) = 6, X-1, if(WEEKDAY(X) = 0, X-2,X ) )


    • Marked as answer by Rebecca Tu Friday, March 27, 2015 8:01 AM
    Friday, March 20, 2015 7:18 PM

All replies