Date and Networkdays

[Stclements1]

I am currently using this formula to provide end of month dates which works perfectly but what I want to do in addition is to make the output to be networkdays only but I cannot workout where I need to add this within the formula to make that happen.
=IF(ROWS(E$2:E2)>($B$4*12);"";EOMONTH(TRIM($B$2);ROWS(E$2:E2)-1))

In addition to this in cell B2 is it possible to have a date format that will let an end user type in a date in dd/mm/yyyy format and get a long date output. when I use the date function it wants me to input in this order yy/mm/dd

 

[jasonb75]

Oops, I only looked at the formula, not the positioning.

=IF(ROWS(E$2:E2)>($B$4*12),"",WORKDAY(EOMONTH(B$2,D2-1)-1,1))

 

[Stclements1]

Absolutely perfect. Thank you so much for your time and efforts.

 

[Stclements1]

I have another query that if I am allowed to ask as it relates to the same spreadsheet is, in cell b9 I have the total interest payable, but the calculation is incorrect. What I need in cell B9 is a formula that calculates the value of all interest payments based on the value in cell B4 so something like SUMIF B4=1;F2:F13,IF B4=2;F2:F25;IF B4=3;F2:F37 but I have tried a similar type formula which unfortunately didn't work.

 

[jasonb75]

Perhaps

=SUM(F2:INDEX(F:F,B4*12+1))

 

[Stclements1]

Once again perfect, many many thanks.