VbScript: Number of days in month

On October 14, 2007 By ntanya54In Technology

Code:


daysInMonth = Day(DateSerial(thisYear, thisMonth + 1, 0))

It adds 1 to the month and uses DateSerial to get a Date representing the 0th day of the following month. That is the last day of the month you entered. The Day function gives you the number of that day, which equals the number of days in the month.

7 thoughts on “VbScript: Number of days in month”

srinivas

Thanx buddy

April 1, 2010 at 8:51 am Reply
cursorblock

This is just what we needed. Thanks. :)

January 14, 2011 at 1:08 pm Reply
Eduardo

Thanks, great piece of code, solved my problem :)

October 17, 2011 at 6:13 pm Reply
Szilard

Thanks :D

June 26, 2014 at 3:54 am Reply
Rod

Thanks …

December 3, 2014 at 12:26 am Reply
Sharath Pai (@sharathpai5)

To the point.. Thanks

October 9, 2019 at 9:17 pm Reply
shalevku

Although it doesn’t affect, the year could change to next year when adding to month, but since it is January stays with 31 days always, it doesn’t matter.

September 12, 2022 at 8:17 am Reply