If weekend date display previous Friday date
=A1+(B1*7)-IF(WEEKDAY(A1)=7,1,IF(WEEKDAY(A1)=1,2,0))
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"jimar" wrote in message ...
| 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?
|