Week Numbering

Hi PMJohnTopley,

Sorry for being a little confusing.

As far as I know WEEKNUM will display week number from 1 to 53.

Is there any way to make the first date of my list as week1.

Ex.

17-05-2015 = Week 1
21-05-2015 = Week 2
29-05-2015 = Week 3

Thanks

=INT((7-WEEKDAY(B2,2)+DAY(B2))/7)+1
try this in B1

=int((7-weekday(b2,2)+b2-$b2+1)/7)+
try this if it is not working for you please attach a sample file

Try this. In B2, then drag across.

="Week "&MAX(SUMPRODUCT(--(WEEKDAY($B$2:B$2,1)=2))+1,1)

In B1...

="Week "&WEEKNUM(B3)-WEEKNUM($B$3)+1

You can copy across... but if you have uneven merged cells going across, you will have to Copy and Paste Formulas.

PS: It'll work up to the point where the calendar year changes....

PPS: Fiscal year solution...

="WEEK "&WEEKNUM(B3-$B$3+WEEKDAY($B$3))

Note end of and beginning of next fiscal year will be indicated as "Week 53" unless the calendar week transition is identical to fiscal week end/begin (I think).

Or maybe something like this??