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.

[TABLE="width: 642"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 642"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Date[/TD]
[TD]Monthly Income Target [/TD]
[TD]MTD Target[/TD]
[TD]MTD Income[/TD]
[TD]Difference[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]01/09/2017[/TD]
[TD]£10,000[/TD]
[TD]£476.19[/TD]
[TD]£400[/TD]
[TD]-£76.19[/TD]
[/TR]
[TR]
[TD]



[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[Scott T]

[TABLE="class: grid, width: 518"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[TD]J
[/TD]
[TD]K
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Name
[/TD]
[TD]Date
[/TD]
[TD]Monthly Income Target
[/TD]
[TD]MTD Target
[/TD]
[TD]MTD Income
[/TD]
[TD]Difference
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Holidays
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Joe
[/TD]
[TD="align: right"]1/9/2017
[/TD]
[TD="align: right"]10,000
[/TD]
[TD="align: right"]476.19
[/TD]
[TD="align: right"]400
[/TD]
[TD="align: right"]76.19
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]list
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]holidays
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]here
[/TD]
[/TR]
</tbody>[/TABLE]

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)