Question: how to calculate number of weeks in a year in excel?
Answer: Excel WEEKNUM Function. The Excel WEEKNUM function takes a date and returns a week number (1-54) that corresponds to the week of year. The WEEKNUM function starts counting with the week that contains January 1.