Suppose in cell 1 i have a date 9/8/2010, can the formula show me whether it is in week1, 2,3,4 respectively?
Thanks for helping!
Pedie;)
I have =WEEKNUM(H45,2) which return week number for whole year...But I am looking for like week1 of sept for instance. thanks again!