Jun 13 2023 12:11 PM - edited Jun 13 2023 01:15 PM
Good afternoon Excel Experts! I am hoping someone can help me create a formula that will allow me to calculate company holidays as days worked, along with the days I designate as working days (Friday, Saturday, & Sunday). I have been able to calculate specific days worked by using the formula below: the =IF(ISBLANK(C26),"",NETWORKDAYS.INTL([@Column1],[@Column2],"1111000"))
Unfortunately, when I add holidays to this formula, it is excluding the holidays designated instead of including them like I want. Can someone please help me add to this formula to INCLUDE designated company holidays as a day worked?
Jun 13 2023 01:08 PM
Jun 13 2023 01:12 PM - edited Jun 13 2023 01:13 PM
The formula I have above does not include the designated company holidays, which fall between Mon-Thurs. My current formula above only captures Friday, Saturday, and Sunday as days worked. I also want to capture the designated holidays for our company as days worked in the date range if it falls between the designated ranges entered.
Jun 13 2023 01:39 PM