I'm looking for a formula that updates a cell date systematically for only Mondays.
For example, this weeks date for Monday is 05/16/16. This date will be updated come next Monday which will fall on 05/23/16. So in other words, the date will change to every Monday only.
I would appreciate your input on this.
Thank you in advance.