COUNTNUMBEROFDAYS

There are 2 functions.


COUNTNUMBEROFDAYS_INAMONTH

Returns the number of days in a month.

Public Function DAYSINAMONTH(ByVal iMonthNumber As Integer, _ 
                           ByVal iYear As Integer) As Integer
   DAYSINAMONTH = VBA.Day(VBA.DateSerial(iYear, iMonthNumber + 1, 1) - 1)
End Function



COUNTNUMBEROFDAYS_INAYEAR

Returns the number of days in a particular year.




© 2018 Better Solutions Limited. All Rights Reserved. © 2018 Better Solutions Limited