Microsoft Visual basic professional ed 6...

hello.. can someone help me on how to get the number or days in a specified month.pls help

You can use the =EOMONTH() function to get what you want. If you have todays date in cell A1

then in cell B1 enter:=EOMONTH(A1,0)

and it will return March 31, 2010 or the end of the month date.

If all you want is the number of days in the month then something like:

=DAY(EOMONTH(A1,0))

will give you the number 31

Just remember to format your cell to reflect the type of info your looking for. A date format or a number format.

Also, the EOMONTH function is part of the Analysis ToolPak, look in your TOOLS - ADD-INS and make sure the Analysis ToolPak is checked.

MIKE

big thanks bro

hello again.. i have already compute all the required computation.. but now how can i save all the result or total of my computation to my table or field.. can you help me again..?

how can i save all the result or total of my computation to my table or fieldI'm sorry, but I do not understand your question.

You will have elaborate a bit.MIKE

well i have the result of computation. these are the total etc,, but i have a data base in ms access.. how can i save those result or total in my database/.

I'm sorry I don't know Access.

Try asking your question in the Database or Programming Forums.MIKE

Ask Your Question

Weekly Poll