A | B | C | D | E | F | |
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 |
<tbody>
</tbody>
Hi Mate
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