if my BI Report.xlsx (1.6 MB) “Estimated ship Date” column has “1/1/1009” then i should add 14 business days (Excluding Sunday and Saturday ) to “Order Date” and update this vale in “Estimated ship Date” column eg: if Order Date=3/05/2021 you should add 14 business days (Excluding Sunday and Saturd…

How to add 14 business day for a column in a data table if you have vale in other column as "1/1/1009"

sandeep_sonu (sandeep B) May 3, 2021, 1:39pm 3

Please refer the below link and you might find a solution

Topic		Replies	Views
How to add 5days to date available in excel Studio studio , question , activities_panel	5	475	December 20, 2022
How to add 2 business days to the date Studio excel , activities , studio , question , activities_panel	9	3268	August 2, 2023
Calculate 15th working day of the month(does not include Saturdays and Sundays) Help datatable , excel , orchestrator , string , question	5	1042	July 31, 2020
I want to add 7 days to the existing date from excel Studio studio , question , activities_panel	6	1286	March 17, 2022
How to add +1 day in excel Community question , community	8	735	November 21, 2022