Count workdays since a date

[BravoBravoAu]

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.


[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Date signed
[/TD]
[TD]Days since
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]1 Jan 18
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]30 Nov 17
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]21 June 16
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]15 Apr 18
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Tetra201]

Is this what you need?

=IF(ISNUMBER(D2),NETWORKDAYS(D2,TODAY()),"")

 

[BravoBravoAu]

@Tetra201 - Yes, that is exactly what I need. I can't for the life of me work out why that didn't occur straight away. Thank you.

 

[Tetra201]

Glad to have helped.