I am trying to figure out how to perform a calendar week number formula, array formula, or maybe it is just a VBA function.
My workbook has a Yearly worksheet, and 1 thru 12 worksheets for each month. The week number is calculated on a end or the week (Saturday) value from a typical looking calendar. The issue is that the end of the month may not always end on a Saturday. So I need to figure out how to move from Right to left in a row until it finds a non zero value in a series of cells.
The attached file has more detail on worksheet "3"
Any guidance here would be appreciated.