| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there any VB command to find out the total no. of days in a month?
As subject, many thanks.
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there any VB command to find out the total no. of days in a month?
Hi
=Day(Dateserial(year,month+1,0)) -- Regards Frank Kabel Frankfurt, Germany "ªü¤T" schrieb im Newsbeitrag ... As subject, many thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there any VB command to find out the total no. of days in a month?
Hello Frank,
Great, many thanks! "Frank Kabel" ¼¶¼g©ó¶l¥ó·s»D ... Hi =Day(Dateserial(year,month+1,0)) -- Regards Frank Kabel Frankfurt, Germany "ªü¤T" schrieb im Newsbeitrag ... As subject, many thanks. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there any VB command to find out the total no. of days in a month?
Hi. "ªü¤T" . One common way is to look at the first day of next month,
but instead of using 1, use 0 to return the previous day. dte = Int(Now) NumDays = Day(DateSerial(Year(dte), Month(dte) + 1, 0)) ' or with atpvbaen.xls loaded... NumDays = Day(EOMONTH(dte, 0)) -- Dana DeLouis Win XP & Office 2003 "ªü¤T" wrote in message ... As subject, many thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running total over a find number of days | Excel Worksheet Functions | |||
| Find days in a Month | Excel Discussion (Misc queries) | |||
| Find the First of the Month after 60 days | Excel Worksheet Functions | |||
| Find the number of days in a month | Excel Worksheet Functions | |||
| how do i display the total number of days in the current month in. | Excel Discussion (Misc queries) | |||
![ªü¤T[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
