JennyPeters
Programmer
Is there a function to determine # days in a month?
Thanks,
Jenny
Thanks,
Jenny
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Dim intMonth, intYear, LastDayOfThisMonth, NoOfDays
intMonth = Me.txtMonth
intYear = Me.txtYear
LastDayOfThisMonth = DateSerial(intYear, intMonth + 1, 0)
NoOfDays = Day(LastDayOfThisMonth)
MsgBox NoOfDays