Microsoft Excel - Working With Dates Part 2
In Part 2 of working with dates we use the INT, DAY and WEEKDAY functions to derive the week number within a month for a given date. The following screen shot shows the desired results, assuming a week starts on a Monday:
Wednesday 1st June 2011 is in week 5 of the previous month (May) as the Monday of that week was ion the previous month.
Monday 6th June is in week 1 as it is the first Monday of June.