Hi all
Looking for a formula that allows a cell to display the Monday date through the year (by default), and updates itself. For example in week 43 of this year, Monday's date is 19/10. The cell needs to display this up to the time that 7 days have past, regardless of how many times the spreadsheet is open.
This new date (eg 26/10) then needs to appear in another cell, in the same spreadsheet.
Hope it makes sense!
Thank you.
Bookmarks