How to display leading zeros using WEEKNUM formula?

[hutchtcoh]

In column A I have the following formula =CONCATENATE((YEAR(B1)), " - ", (WEEKNUM(B1,1)))

In column B I have a date.

I need column a to display in YYYY-MM format.

This works great from about mid-March thru the end of the year when the week number is 10 or greater. As an example when the date is 1/31/2012, column A displays as 2012 - 5. For sorting purposes, I need it to display as 2012 - 05.

 

[VoG]

Try

=CONCATENATE(YEAR(B1), " - ", TEXT(WEEKNUM(B1,1),"00"))

 

[Firefly2012]

Hi

Try:

=YEAR(B1) & " - " & TEXT(WEEKNUM(B1,1),"00")

 

[Andrew Poulsom]

Welcome to MrExcel.

Try:

=CONCATENATE((YEAR(B1)), " - ", TEXT(WEEKNUM(B1,1),"00"))

 

[SteveO59L]

=concatenate((year(b1)), " - ", if(len(weeknum(b1,1))=1,"0"&weeknum(b1,1),weeknum(b1,1)))

 

[hutchtcoh]

Thanks to all that replied ... corrected my issue.