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

  • Thread starter Thread starter =?big5?B?qvykVA==?=
  • Start date Start date
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))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Last Day of the month 6
VBA - Work out How Many Days are in a Month 6
Excel Message box with days of month & date. 1
VB Code to Auto Save Multiple Files 0
Save data from Notebook: copying to the USB stick using Linux and the command line 0
Quick Access Tool Bar 1
How do I find what is in a spreadsheet 4
3 month rolling totals 2

Back
Top