BravoBravoAu
Board Regular
- Joined
- Nov 8, 2011
- Messages
- 63
- Office Version
- 2016
- Platform
- Windows
Hi guys - I'm confident this is an easy fix but I can't seem to crack it.
I'm looking to calculate the workdays since another particular date. I'm sure its NETWORKDAYS and TODAY but I'm struggling. The first date is column D and days since is column E and the table is currently 50 rows, however some cells in column D are empty (to possibly have dates entered at a later date).
I assume there is also a recalculation each time the sheet is opened? Thanks for any help given.
<tbody>
</tbody>
I'm looking to calculate the workdays since another particular date. I'm sure its NETWORKDAYS and TODAY but I'm struggling. The first date is column D and days since is column E and the table is currently 50 rows, however some cells in column D are empty (to possibly have dates entered at a later date).
I assume there is also a recalculation each time the sheet is opened? Thanks for any help given.
D | E | |
1 | Date signed | Days since |
2 | 1 Jan 18 | |
3 | 30 Nov 17 | |
4 | 21 June 16 | |
5 | 15 Apr 18 | |
6 |
<tbody>
</tbody>