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
Seth wrote:
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