It also allows us to skip specified holidays. Extract the week of year from the date of the first day of the month the date falls within. 30 days from date.
Decide if you want to exclude holiday dates.
We can change the number format to a Fraction to display the number of days. In the example shown the formula in C5 copied down is. To calculate the date range by the specific week number you can use the following formulas. If you need to calculate a number of complete weeks passed from some date use the formula.