# Obtain Year and Week Number.

1. ## Obtain Year and Week Number.

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...

I will appreciate the big support.

SamCV.
Matamoros, Mexico.

2. ## Re: Obtain Year and Week Number.

Hello

Try

Formula:
`Please Login or Register  to view this content.`

Formula:
`Please Login or Register  to view this content.`

3. ## Re: Obtain Year and Week Number.

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

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

4. ## Re: Obtain Year and Week Number.

Or this

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

5. ## Re: Obtain Year and Week Number.

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

6. ## Re: Obtain Year and Week Number.

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

Very awesome work!!

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

SamCV.
Matamoros, Mexico.

7. ## Re: Obtain Year and Week Number.

Thanks for the feedback!

8. ## Re: Obtain Year and Week Number.

Originally Posted by spodurinagasiva
=TEXT(WEEKNUM(G3,1),"DD")
It wouldn't be a good idea to use this, what if the date in G3 is 8/8/2014?

There are currently 1 users browsing this thread. (0 members and 1 guests)