I need a formula that will find the week number of a month. Sometimes, there are 5 weeks in a month and I need the formula to be able to adapt to that. I want to take the data out of one cell that has a date in it. My workplace has Excel 2003, and I can't use any macros or add-ins. The formula needs to be made from existing formulas in Excel 2003.
For example: The date I am referencing for the formula is January 1, 2012. I need the formula to reflect that this is week 1, but just the number, not the word week. If I were to reference the same cell that originally had January 1st in it with a different date, say February 29, 2012, then I need the formula to display that this is week 5.
I define the first or last week of a month by whatever month has the most days in the week. For January of this year - the 29th, 30th, and 31st are in the first week of February because February has 4 out of 7 days in the week.
Bookmarks