Date Functions

[Seth]

Is there a native function in VBA to determine the number
of days in a specified month? For example, if I wanted
to know how many days were in January is there a function
that would return 31. This is also important for
February given leap year and all that good stuff.

Thanks,

Seth

 

[Frank Kabel]

Hi Seth
if your date is in A1 the following formula calcualtes how many days
are within that specific month:
=DAY(DATE(YEAR(A1),MONTH(A1)+1,0))

for mor information on dates/times see
http://www.cpearson.com/excel/datetime.htm

Frank