How do I make a week start on Monday in Excel?
How do I make a week start on Monday in Excel? Formula: =A2-WEEKDAY(A2,2)+1 Note: This formula =A2-WEEKDAY(A2,2)+1 will return Monday as the beginning of week based on the given date. How do I start a Weeknum on Monday? C5*7 adds the number of weeks multiplied by 7 (the number of days in a week) to […]