Is there any VB command to find out the total no. of days in a month?
 

As subject, many thanks.

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.

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.

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.