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.
What is the best way to workout a formula that calculates the difference between two dates but also factors in weekends and the country holidays.
E.g if the Difference between two days is 8 and there is a weekend in between, the no of days would be 6 but if there was a public holiday also in between these two days, it would bring the diff to 5.
Refer to attached file with first worksheet that has the two dates i want to calculate the difference. Request Creation Date is 29th July and Approval Date is 6th Aug. I've also created a dummy public holiday 5th Aug.
What is the best way to calculate the difference between these two dates and exclude the weekends (Sart and Sun) as well as the dummy public holiday.