This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am looking to calculate the "Day Factor" column below. If i have a date range, i want to assign Business Days as 1 and non business days as 0. This portion is already predefined. The question i have, is that if a Business day is followed by a non business day, i want to assign the weekend days to the last business day before the non business day. Hence, below for 4/3/20, since it is a Friday, its day factor is 3 (it's counting Friday, Saturday and Sunday). For 4/9/20, its day factor is 4 (counting Thursday, Friday, Saturday, Sunday) since Friday is a Holiday.