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
Please see attached file...
Thanks in advance...
Karnik
in B2
=TEXT(A2,"mmm")&" "&YEAR(A2)&" W"&INT(DAY(A2)/7)+1
and copy down the column
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
=text(a2,"mmm yyy")&" w" &c2
or
=TEXT(A2,"MMM YYY")&" W" &TRUNC(((A2-DATE(YEAR(A2),1,0))+6)/7)
Last edited by martindwilson; 11-26-2012 at 08:08 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hello SpecialK and marindwilson,
Both suggestion works and very different... brilliant variety of solutions...
Thanks a million
Karnik
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks