Monday 25 September 2006 @ 8:56 am
Many of you have used the Business Days formula on my web site to determine the number of ‘working days’ between two dates – not counting weekends and holidays. The instructions remind you that since weekends are removed automatically that you should not include holidays in your exclusion list if they are going to fall on a weekend. If you do the holiday will be deducted twice.
Jason Lewis of Sydney, Australia suggested that the formula could automatically screen out any entered holidays that fall on the weekend. He gave me an example modification and I tweaked it a bit. The improved version is now posted on my web site.
(For examples of my most popular formulas, please visit the FORMULAS page on my website.)