Formula to Calculate Leave as per Custom Start and End Date of the Month

Hello All,

I am using Excel 2013 and I am issue with a Formula to calculate Leave as per the
Start and End Date of the Month.

Start Date is 21st of the Month

End Date is 20th of the Month

If the Employee is going on leave eg Start Date is 8th July and returns back on 22nd July
(See Row No 4 in the sample attached) Networkdays.Intl gives the results as 11 but I would like to have it as 9 which should not include 21st and 22nd as it is falling after the end date which is 20th of the Month.

I have highlighted cells in Column G what is the expected results.

Any help would be greatly appreciated.

Try this:

=NETWORKDAYS.INTL(B2,IF(DAY(B2)>=20,C2,MIN(C2,DATE(YEAR(C2),MONTH(C2),20))),1)

If there are further requirements, please start a new thread with a suitable title.