This is part six of the Excel Tutorial Series. Read all tutorial posts by browsing the Tutorial category.
Let's continue the macro tutorial series with the following topics.
Continue Reading: Excel Tutorial Series – VBA Macros, Part Two Of Two »
Calculate working days from start date
February 9, 2009 by · 
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 »
Add To Outlook Calendar UDF
September 10, 2008 by · Here is a simple UDF that adds an appointment to your Outlook calendar. It can be used from Excel or VBA, and it should be usable from Access as well (untested). It uses another concept I've also been trying out: checking functions to make sure they are successful by using Boolean return values. I believe I read this in Professional Excel Development, but I'd be hard pressed to find the page number. 
Continue Reading: Add To Outlook Calendar UDF »
Follow Me