Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Functions
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Functions
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date functions | Excel Worksheet Functions | |||
date functions | Excel Worksheet Functions | |||
Date and Sum functions (HELP) | Excel Discussion (Misc queries) | |||
Date Functions | Excel Discussion (Misc queries) | |||
Date functions | Excel Worksheet Functions |