VBA Leap Year Test
Working on a calendar project I needed a test for leap years. As an alternative to the standard 'divisible by four' approach, try the following which even works for 1900:
Function QueryLeapYear() Dim d As Integer On Error GoTo handler d = Weekday("29/02/1900") Exit Function handler: Debug.Print "Not a leap year." End Function
Control passes to the error handler if the Weekday() function cannot return a day number from the supplied date.
0 Comments:
Post a Comment
<< Home