Month to Number format

[manfareed]

Hi ,

I need to extract November as "11" from November 2007. But this can change
depending on the current month eg. "12" from December 2007.

"11" should be in number format so that it can be used in calculations to
calculate average costs.

Thanks,

 

[sebastienm]

Hi,
Not sure I understand it...
Say you have a full/partial date in A1
Anywhere else on the sheet, use =Month(A1) to return the month number. eg:
= IF ( Month(A1) = 11, ..., ... )

 

[crferguson]

Hi ,

I need to extract November as "11" from November 2007. But this can change
depending on the current month eg. "12" from December 2007.

"11" should be in number format so that it can be used in calculations to
calculate average costs.

Thanks,

Just use the Month() function...

Private Sub test()
Dim s As String, n As Integer
s = "November 2007"

n = Month(s)

End Sub

 

[manfareed]

Hi Thank you both. That works perfectly.