Week Num Function

[tinumathews]

Hi, I need help here... My weeknum function gives me the week number. Lets say that the date is Feb 3, 2012, weeknum will show the number as "6", Is there any way that the cell shows Feb week 1, Mar week 3 and so on....

 

[SirJB7]

Hi, tinumathews!

Weeknum function retrieves a number, so you can't do it just with this function. Supposing your date is in A2, try this:

=CONCATENATE(TEXT(MONTH(A2),"mmm")," ",TEXT(WEEKNUM(A2),"00"))

Regards!