M Mohandas Member May 31, 2016 #1 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
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
N NARAYANK991 Excel Ninja May 31, 2016 #2 Hi , See if this helps : http://chandoo.org/forum/threads/week-num-required.23649/#post-142900 Narayan
Hi , See if this helps : http://chandoo.org/forum/threads/week-num-required.23649/#post-142900 Narayan
B bosco_yip Excel Ninja May 31, 2016 #3 NARAYANK991 said: See if this helps : http://chandoo.org/forum/threads/week-num-required.23649/#post-142900 Narayan Click to expand... 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 Last edited: May 31, 2016
NARAYANK991 said: See if this helps : http://chandoo.org/forum/threads/week-num-required.23649/#post-142900 Narayan Click to expand... 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
