This, My Life
If weeks begin on Monday, the following function tells you what week number of a month (e.g., Week #1 or Week #3 within January) the date in cell J1 is within:
=TRUNC(((WEEKDAY(DATE(YEAR(J1), MONTH(J1), 1),2)+DAY(J1)-1)-1)/7)+1
If weeks begin on Monday, the following function tells you what week number of a month (e.g., Week #1 or Week #3 within January) the date in cell J1 is within:
=TRUNC(((WEEKDAY(DATE(YEAR(J1), MONTH(J1), 1),2)+DAY(J1)-1)-1)/7)+1