Hi,
If I have a date range in excel, lets say for example 8th Feb 2021 - 25th Feb 2021 am I able to create a formula that works out what weeks of the year that date range falls in and how many workdays (excluding weekends) per week.
Heres how I'm hoping it will work:
8th Feb-25th Feb falls in weeks 7-9 in the year (using excels weeknum funtion) for this particular date range there is a total of 5 workdays in week 7, 5 workdays in week 8 and 4 workdays in week 9.
Thanks.
If I have a date range in excel, lets say for example 8th Feb 2021 - 25th Feb 2021 am I able to create a formula that works out what weeks of the year that date range falls in and how many workdays (excluding weekends) per week.
Heres how I'm hoping it will work:
8th Feb-25th Feb falls in weeks 7-9 in the year (using excels weeknum funtion) for this particular date range there is a total of 5 workdays in week 7, 5 workdays in week 8 and 4 workdays in week 9.
Thanks.