Have a simple spreadsheet in Excel 365 with a column of cells for each week of the month.
A3 = 21/02/01 A4 = A3+7 A5=A4+7 A6=A5+7 This is fine for February, but for March we have to add an extra row for the extra week. Is there a way to show IF the date in A6 is within 7 days of the end of month, then leave the cell blank, otherwise show A6+7
Thank you
Bookmarks