Help with holiday planner

[bravoball]

Been trying to figure this out for a while and nothing seems to be working.

I am trying to create a holiday tracker that counts weekdays in a week by week from a too and from date. The set up is as follows

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[TD]16th Apr[/TD]
[TD]23rd Apr[/TD]
[TD]30th April[/TD]
[/TR]
[TR]
[TD]John Smith[/TD]
[TD]16th Apr 18[/TD]
[TD]18th Apr 18[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sam Jones[/TD]
[TD]17th Apr 18[/TD]
[TD]18th Apr 18[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Smith Sam[/TD]
[TD]17th Apr 18[/TD]
[TD]25th Apr 18[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]John Jones[/TD]
[TD]18th Apr 18[/TD]
[TD]3rd May 18[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]


I am sure its an if statement but I just can't seem to get it to work.

Any help would be much apprenticed.

Thanks

 

[bravoball]

Forgot to mention what I am looking for help with.

Basically, I am looking for a formula that would calculate the days e.g. 3 for John Smith

Thanks

 

[JumboCactuar]

Don't have access to excel atm but should be easily done with NETWORKDAYS

Which counts between 2 days excluding Saturday and Sunday.