Week Number And Week Start Day of Week

[Rajesh Kr Joshi]

Hi,

I wants to calculate the week for a given date. I have dates in column c2 to c32 (1-Oct to 31st Oct), in B2 to B32 i wants to show in which week (i.e. 3rd Oct,10th Oct, 17 Oct.. etc) these dates are falling in.

Thanks
Rajesh

[Admin]

Hi,

Try

=WEEKNUM(C2,1)


Return_type is a number that determines on which day the week begins. The default is 1.

Return_type Week Begins

1 Week begins on Sunday. Weekdays are numbered 1 through 7.
2 Week begins on Monday. Weekdays are numbered 1 through 7.

[Rajesh Kr Joshi]

Hi,
This will give me the week number, but i want the week start date.

Thanks
Rajesh

[Excel Fox]

=C2-WEEKDAY(C2,2)+1

[Rajesh Kr Joshi]

Simply awesome :) thanks