title: Formula in excel to count back 14 days & show following monday, but count back only 7 days if date entered is a monday
body: <p>I need to be able to enter a date that will count back 14 days and show the next Monday e.g. enter 25/12/2015 and get a return of 15/12/2015, however at the same time if I enter a date that happens to be a Monday it will only count back 7 days e.g. enter 15/12/2015 and get 08/12/2015 February. Tried using this formula but anytime i enter a date that is a Sunday it skips forward to the upcoming Monday...!!??! </p>
  
  <p>=IF(WEEKDAY(D4)&lt;2,D4+2-WEEKDAY(D4),D4+2-7-WEEKDAY(D4))</p>
  
  <p>Thanks everyone</p>