Question: how to calculate number of weeks in month in excel?
Answer: Extract the 'week of year' from the date.
Extract the 'week of year' from the date of the first day of the month the date falls within.
Subtract the two week numbers and add one (so that the first week does not appear as zero).