1st case: We use Excel’s WEEKNUM function to start from 1 every time we reach the 1st of the next month.
2nd case: We reset the week number to 1 every time we reach the first Monday of the next month. Here we use Excel’s WEEKDAY function as the main formula driver.
In addition you will learn how to:
1. Get Week Number from a date with the WEEKNUM formula
2. How to Get the Day name from a date using the WeekDay function
3. How to use the DATE function (Year, Month, Day)
Watch the steps in this video:
Feel free to Download the Workbook HERE.
The new Excel Dashboards course is here!
Now available on Udemy
Visually Effective Excel Dashboards for your reports.
Redeem your coupon for 75% off below.