Find the Last Working Day Of Next Month
Category:
Dates and MathType:
SnippetsDifficulty:
BeginningAuthor:
Keith OllertonVersion 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: