Getting the integer of the month

[SilverShark9]

I have a quick question. I'm looking to get the current month's value (for example, it's November right now, so I should get the value of 11; May would be 5...etc.)

Is there a function to do this with?

Thanks in advance.

[Bob Phillips]

Try

=MONTH(A1)

where A1 holds the date to test

[General_Kaos]

Or without using a cell on the worksheet:

Dim thismonth as integer

thismonth = Month(Now)

[Bob Phillips]

Is there a function to do this with?