| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Number Of Days in a month
Hi
try Sub foo() Dim date_value As Date date_value = CDate("01.03.2004") MsgBox Day(CDate(Month(date_value) + 1 & "-" & "1-" & Year(date_value)) - 1) End Sub you may have to adapt the CDate part to your regional date settings -- Regards Frank Kabel Frankfurt, Germany Charles wrote: Hi I need to find uot how many days are in a month in VBA is there a way of doing this if so can someone help me please TIA Charles |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of days in month counted from shortened name of month & yea | Excel Worksheet Functions | |||
| Finding the number of Days in the month? | Excel Discussion (Misc queries) | |||
| Number of Days in the Month | Excel Discussion (Misc queries) | |||
| How can I add up lookups? Finding days in a week of a month | Excel Discussion (Misc queries) | |||
| number of days in a month | Excel Worksheet Functions | |||
Threaded Mode
