Cell A1 contains a date. Cell B1 contains the number of weeks to be added to
cell A1. I need cell C1 to show the result of A1 plus the number of weeks,
however if the result date falls on a Saturday or Sunday I need the cell in
C1 to show the preceeding Friday date. Can anyone help please?