PDA

View Full Version : Getting the integer of the month



SilverShark9
11-29-2009, 02:35 PM
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
11-29-2009, 03:03 PM
Try

=MONTH(A1)

where A1 holds the date to test

General_Kaos
11-30-2009, 08:22 AM
Or without using a cell on the worksheet:

Dim thismonth as integer

thismonth = Month(Now)

Bob Phillips
11-30-2009, 08:32 AM
Is there a function to do this with?