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.
Please follow steps:
1.Create a Date and Time column named "Test_Data"
2.Then, create a Calcalated column called "Transmit Date" and copy the following formula to the Calcalated column：
Note: The “21” represents the number of working days
3.The Final Display：
====================== Updated Answer =======================
By default, users need add square brackets ( [ ] ) for Column Name.
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)))