After weeks of research & digging down various forums, I haven't been able to find solution to this.
Basically need to calculate WeekNumber on Monthly basis for 2014.
Starting day of the week should be Monday; however, if 1st of any month falls on a Saturday or a Sunday, then Saturday and/or Sunday should be treated as Week 1 along with the following Monday to Sunday i.e. a week of total 9 days.
The attached Excel sheet explains this better.
I also need to calculate No. of Business Days in each week assuming Mon-Fri being the Business Days in this instance. (See sheet again)
I've tried many formulas, some work for some of the months & some work for the other months. I need 1 generic formula to give the desired results. Please have a look and help guys. Thanks heaps!
Bookmarks