Signature (Visual Basic / VBA)
Public Function DaysInMonth( _
ByVal vDate As Variant _
) As Variant
Code Example
DaysInMonth(#1/15/2000#) = 31
DaysInMonth(#2/15/2000#) = 29
DaysInMonth(#2/15/2001#) = 28
DaysInMonth(#3/21/2001#) = 31
Parameters
| Parameter | Description |
|---|---|
| vDate | The date whose month is examined to determine the last day of the month. Function returns Null if vDate is Null or cannot be fixed up to a Date. |