# Calculated Column 21 business days from start date

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.Create a Date and Time column named "Test_Data"

2.Then, create a Calculated column called "Transmit Date" and copy the following formula to the Calculated 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

3.The Final Display：

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

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

Eg. =[Column1]+[Column2]

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