Quarterly dates problem

**siobeh** · 01-27-2014, 05:18 PM

Hi,

Could you please help me with my problem.

I just want to determine the month quarter if:

1. if month today is equals to 'January' or 'February' or 'March' then textbox1.value = "1"
2. if month today is equals to 'April' or 'May' or 'June' then textbox1.value = "2"
3. if month today is equals to 'July' or 'August' or 'September' then textbox1.value = "3"
4. if month today is equals to 'October' or 'November' or 'December' then textbox1.value = "4"

Thank you advance!

**siobeh** · 01-27-2014, 05:38 PM

What is wrong with my below code?

Please Login or Register  to view this content.

**jmac1947** · 01-27-2014, 10:28 PM

siobeh,

what research have you done on your problem before posting to the forum??

this is from the vba help obtained from the vba editor, top right corner, type month enter and this is what you get

Month Function

Returns a Variant (Integer) specifying a whole number between 1 and 12, inclusive, representing the month of the year.

I am using 2010 so I cannot verify what you will see in your version of excel

maybe this is what you should be using??