|1||Name||Date Start||Punishment||Discount||Punishment||Date Release|
|2||Prisoner A||13 Jul 17||90 Days||30 Days||60 Days||10 Sept 17|
|3||Prisoner B||26 Jul 17||80 Days||27 Days||53 Days||16 Sept 17|
These time i was working to make some prison data
The table as show above. My problem is on cell F2 & F3
On F Column i want to make date release is on workday.
For ex: F2 is Sunday, so the prisoner should release on Friday (8 Sep 17)
Also happen to F3, prisoner should release on Friday (15 Sep 17)
I want some help how to build formula on F Column.
Please help me if you can. tQvm