Weekly calendar 2020 in one formula - Excel Exercise
https://www.excel-exercise.com/weekly-calendar-2020-in-one-formula/
Now, November 1, 2020 is a Sunday. So, in this situation, the formula returns to 01/11/2020 If your weekly calendar starts on Monday, the formula is: =IF (WEEKDAY (B5,3)=7,B5,B5-WEEKDAY (B5,3))
DA: 73 PA: 99 MOZ Rank: 40