Excel iconVBA icon

Calculate working days from start date

In the comments for Calculate Working Days Minus Holidays in VBA, Dave asks if there is a function that lets you specify a start date and number of hours, and have the function return the ending business day.

Continue Reading: Calculate working days from start date »

Outlook icon

Do you need to update your Outlook calendar holidays?

In issue 33 of the Exchange Messaging Outlook (EMO) newsletter, they mention that the holidays list in the Outlook 2003 calendar has run out (as of 2007!).

Continue Reading: Do you need to update your Outlook calendar holidays? »

Excel icon

Calculate Working Days Minus Holidays in VBA

I was looking for a function that calculates working days, minus holidays, for a small project I've been working on. I decided to write one myself, but below I've also demonstrated an alternate way that uses the ATP (Analysis ToolPak) functions for VBA.

Continue Reading: Calculate Working Days Minus Holidays in VBA »

Site last updated: February 9, 2012