Obtain Year and Week Number.

**SamCV** · 03-07-2014, 12:50 PM

Hello to all -

I have a Table with dates. In Cell G3 I have the date 2/21/2014.

I need a formula in cell B3 to get Year and Week Number as follows: 2014/02

I have been searching but all that I have found results in 2014/2
Weeks 1 to 9 are shown as 1, 2, 3...

I need Week numbers to be shown like 01, 02, 03...

Can you please help me with a formula to get the result that I need??

I will appreciate the big support.

SamCV.
Matamoros, Mexico.

**Fotis1991** · 03-07-2014, 12:57 PM

Hello

Try

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

**spodurinagasiva** · 03-07-2014, 01:00 PM

You can use a combination of TEXT and WEEKNUM functions to get your results

In your example
it will be WEEKNUM(G3,1). This gives you a result of 8
To this, you use the TEXT function

TEXT(WEEKNUM(G3,1),"DD"). This will give you result as 08

To get the formula to your question

=CONCATENATE(YEAR(G3),"/",TEXT(WEEKNUM(G3,2),"DD"))

Hope you this helps

KP

**AlKey** · 03-07-2014, 01:02 PM

Or this

=YEAR(G3)&" / "&TEXT(WEEKNUM(G3),"00")

**bebo021999** · 03-07-2014, 01:03 PM

Maybe:
=YEAR(G3)&"/"&TEXT(WEEKNUM(G3),"00")

**SamCV** · 03-07-2014, 01:15 PM

Very quick answers!! And all of them work perfectcly!!!

Thank you all for your help and advise!!
Very awesome work!!

I had add points of reputation to all of you.

Please have a great day and an excellent weekend.
(Que tengan un gran día y un excelente fin de semana).

SamCV.
Matamoros, Mexico.