MTD target calculator

[Toffalof]

Hello, Could anyone help me. I'm not very good at Excel and need the formula's for the following.
My target for the month needs to be split by the number of workings days and then the MTD figure worked out depending on date input.
I will enter the Income figure daily but I need everything else to have a formula.
Please see below for a more easier example.

Name Date Monthly Income Target MTD Target MTD Income Difference Joe 01/09/2017 £10,000 £476.19 £400 -£76.19 <colgroup><col><col><col><col><col><col></colgroup><tbody> </tbody>

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Scott T]

	A	B	C	D	E	F	G	H	I	J	K
1	Name	Date	Monthly Income Target	MTD Target	MTD Income	Difference					Holidays
2	Joe	1/9/2017	10,000	476.19	400	76.19					list
											holidays
											here

<tbody>
</tbody>

In D2. Change the 1 to match the weekends you want.

=ROUND(C2/NETWORKDAYS.INTL(DATE(YEAR(B2),MONTH(B2),1),EOMONTH(DATE(YEAR(B2),MONTH(B2),1),0),[COLOR=#ff0000]1[/COLOR],K2:K5),2)