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!

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 ) )

Robin his approach is fine. All the IFs can be replaced with the CHOOSE function:

=X - CHOOSE( WEEKDAY(X)  , 2 , 0 , 0 , 0 , 0 , 0 , 1 )

https://support.office.com/en-au/article/CHOOSE-function-f981a30c-634b-4d6d-896e-1495f0a91e89

Also see WEEKDAY

https://support.office.com/en-nz/article/WEEKDAY-function-a9784177-5c31-4deb-bc9e-d4ab914983ca

Robin says weekday 6 is Saturday, but thats not the default setting for weekday

• Edited by ViewMaster365.com 20 hours 33 minutes ago