Extract the Week Number

[notorious_eagle]

Hi All,

I am trying to extract the week number in my spreadsheet. The list goes long below for months. I need a way that some how i can extract the week number and also the month. Below is an example of the type of data list i have:

03/02/2014
07/02/2014
12/03/2014

Thanks a lot for your help

[Ace_XL]

For weeknumber
=WEEKNUM(A1)

For month
=MONTH(A1)

[hoyasaxa215]

=weeknum
=month

[hoyasaxa215]

=weeknum
=month