thedeadzeds
Active Member
- Joined
- Aug 16, 2011
- Messages
- 450
- Office Version
- 365
- Platform
- Windows
Hi Guys, i'm wondering if the below is possible. My weeks run from Thursday to Friday so is there a way to use a formulas to pull out the Friday date within that week. The result would need to look like the 'Week ending formula' column below
Thanks
<tbody>
</tbody>
Thanks
Date | Week Ending formula |
04/05/2018 | 10/05/2018 |
05/05/2018 | 10/05/2018 |
06/05/2018 | 10/05/2018 |
07/05/2018 | 10/05/2018 |
08/05/2018 | 10/05/2018 |
09/05/2018 | 10/05/2018 |
10/05/2018 | 10/05/2018 |
11/05/2018 | 17/05/2018 |
12/05/2018 | 17/05/2018 |
13/05/2018 | 17/05/2018 |
14/05/2018 | 17/05/2018 |
15/05/2018 | 17/05/2018 |
16/05/2018 | 17/05/2018 |
17/05/2018 | 17/05/2018 |
18/05/2018 | 24/05/2018 |
19/05/2018 | 24/05/2018 |
20/05/2018 | 24/05/2018 |
21/05/2018 | 24/05/2018 |
22/05/2018 | 24/05/2018 |
23/05/2018 | 24/05/2018 |
24/05/2018 | 24/05/2018 |
<tbody>
</tbody>