# Function required to put each month days in to four week

1. ## Function required to put each month days in to four week

Hello Excel Gurus,

I have dates running in to one column and managed to get them in weeks-number as suggested by forum contributor Sixthsense.
I require function to look at date and week-number to give for all Jan 1-7 dates in result as "Jan 2009 W1" for 1st week and so on
Karnik

2. ## Re: Function required to put each month days in to four week

in B2
=TEXT(A2,"mmm")&" "&YEAR(A2)&" W"&INT(DAY(A2)/7)+1
and copy down the column

3. ## Re: Function required to put each month days in to four week

=text(a2,"mmm yyy")&" w" &c2
or
=TEXT(A2,"MMM YYY")&" W" &TRUNC(((A2-DATE(YEAR(A2),1,0))+6)/7)

4. ## Re: Function required to put each month days in to four week

Hello SpecialK and marindwilson,
Both suggestion works and very different... brilliant variety of solutions...
Thanks a million
Karnik

5. ## Re: Function required to put each month days in to four week

INT(DAY(A2)/7)+1 gives 7 jan as wk 2

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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1