Find the Last Working Day Of Next Month

Category:
Dates and Math
Type:
Snippets
Difficulty:
Beginning
Author:
Keith Ollerton

Version Compatibility: Visual Basic 6, Visual Basic 5

More information:
This function returns the last working day of the next month(Monday - Friday ignoring holidays) for a given date:

It consists of two functions - the IsLeapYear function is a direct copy of that by Brian Gillham (at http://acs.nv.net/freevbcode/ShowCode.Asp?ID=391).

The function could be easily changed to show last working date of the current month or any number of months following.

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:

Code: