Week numbers for a date in the month

[Mohandas]

Dear Sir,

what formula can be used to get the week number for a given date in a month

for example 15.05.2016 is week 3

Regards

Mohandas

 

[NARAYANK991]

Hi ,

See if this helps :

http://chandoo.org/forum/threads/week-num-required.23649/#post-142900

Narayan

 

[bosco_yip]

See if this helps :
http://chandoo.org/forum/threads/week-num-required.23649/#post-142900
Narayan

Thanks to Narayan link related post.

1] Narayan link of replied post from barry houdini, formula is :

=INT((6+DAY(A1+4-WEEKDAY(A1-1)))/7)

The above formula return week number based on week always begins on Monday,

in testing with the OP's example 15/05/2016, the above formula return 2. (not 3)

2] I guess OP's specification in week begins on Sunday, then the modified formula is :

=INT((6+DAY(A1+4-WEEKDAY(A1-7)))/7)

and the 2nd formula return 3.

Regards
Bosco