1

I have a field that is called Transmit Date, I need to generate a calculated column 21 business days from the date of this field. I have seen some other posts that fall within a week. I am curious how I set this up for 21 business days.

1 Answer 1

1

Please follow steps:

1.Create a Date and Time column named "Test_Data"

enter image description here

2.Then, create a Calcalated column called "Transmit Date" and copy the following formula to the Calcalated column:=IF(WEEKDAY(Test_Data)=1,Test_Data+21+2*4,IF(WEEKDAY(Test_Data)=6,Test_Data+21+2*5,IF(WEEKDAY(Test_Data)=7,Test_Data+21+2*4+1,Test_Data+21+2*4)))

Note: The “21” represents the number of working days

enter image description here

3.The Final Display:

enter image description here

====================== Updated Answer =======================

By default, users need add square brackets ( [ ] ) for Column Name.

Eg. =[Column1]+[Column2]

More information, please refer to Calculated Field Formulas.

Calcalated column formula:

=IF(WEEKDAY([Transmit Date])=1,[Transmit Date]+21+2*4,IF(WEEKDAY([Transmit Date])=6,[Transmit Date]+21+2*5,IF(WEEKDAY([Transmit Date])=7,[Transmit Date]+21+2*4+1,[Transmit Date]+21+2*4)))

enter image description here

2
  • Thank you for looking at this. Still having trouble. In your example above your Test_Data is my Transmit Date and my Transmit Date is called Due Date. When putting this into the SharePoint list I get an error. I modified in one instance putting square brackets around Transmit Date bcs that seems to be how it usually wants the calculation of a field. However, I tried both ways: =IF(WEEKDAY[Transmit Date]=1,[Transmit Date]+21+2*4,IF(WEEKDAY[Transmit Date]=6,[Transmit Date]+21+2*5,IF(WEEKDAY[Transmit Date]=7,[Transmit Date]+21+2*4+1,[Transmit Date]+21+2*4))) - Any suggestions?
    – Elaine
    Jan 22, 2021 at 11:42
  • Hi, Elaine. Thanks for your reply. I have updated my answer, hope this can help you. Have a nice day! Jan 25, 2021 at 9:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.