There are 2 functions.
For instructions on how to add a function to a workbook refer to the page under Inserting Functions


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


Returns the number of days in a particular year.

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext