Week Numbering

[amitananddey]

Hi Folks,

I am new into excel and I have a noobish question.
I am not able to get the week numbering done.

Please check the image to get a detailed info.
WeekNum.jpg
I want the week numbering done in formula without having to write it manually.

Any leads will be really helpful.

Thank you,
Anand

[JohnTopley]

See WEEKNUM function

[amitananddey]

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

[samba_ravi]

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

[samba_ravi]

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

[VLB]

Hi,

I"m thinking of using something like

Please Login or Register  to view this content.

Cheers,

Vlb

[kvsrinivasamurthy]

Try this. In B2, then drag across.

Please Login or Register  to view this content.

[jhren]

In B1...

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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

[popipipo]

Or maybe something like this??

[amitananddey]

Thank you all guys for such quick and efficient answers.
Hats off to you all.

Thanks you again for helping me out.

[BlindAlley]

Or maybe something like this??

That worked a treat for me too - Thanks