Changing date to week number

**perducci** · 03-16-2012, 05:34 PM

I can't seem to figure this one out.

I want to calculate a month and week number from a date. Each week starts on a Friday. So whatever month the Friday is in determines the month and week number.

For example,

1/6/2012 - 1/12/2012 is January week 1
1/13/2012 -1/19/2012 is January week 2
...
2/3 - 2/9 is February week 1
etc.

How can I make this calculation?

See the attached file. And thank you

**Fotis1991** · 03-16-2012, 05:40 PM

Hi

In C3.

=INT((DAY(A3)-1)/7)+1

Copy down

**haru** · 03-16-2012, 05:49 PM

Going on what Fotis did:

if date is in A2:

Please Login or Register  to view this content.

**daddylonglegs** · 03-16-2012, 07:26 PM

Originally Posted by perducci

....Each week starts on a Friday. So whatever month the Friday is in determines the month and week number

Taking into account this stipulation you can get the week number alone with this formula

=INT((6+DAY(A3+1-WEEKDAY(A3+2)))/7)

format as general

or if you want week number and month like "January week 3" then use this version

=TEXT(A3+1-WEEKDAY(A3+2),"mmmm")&" week "&INT((6+DAY(A3+1-WEEKDAY(A3+2)))/7)