DAYSINAYEAR

Returns the number of days in a particular year.


Remarks

* For instructions on how to add a function to a workbook refer to the page under Inserting Functions
* The equivalent Excel formula is Number of days in a particular year
* The equivalent JavaScript function is DAYSINAYEAR


Public Function DAYSINAYEAR( _ 
         ByVal iYear As Integer) As Integer

   DAYSINAYEAR = VBA.DateSerial(iYear + 1, 1, 1) - VBA.DateSerial(iYear, 1, 1)
End Function


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