adding 15 workdays on the following month from a start date

[ROCKY19]

Hello,

any assistance will be greatly appreciated.

I need to get the 15th working day of the next following month of a start date.

I figured it out but I have the formulas in two different cells to get my results. I used EOMONTH to get the end of the month of my start date +1 to get the first day of the next month, then i use another formula(WORKDAY) to get the 15th workday.

I would like to combined both formulas in one cell and still get the same result. can this be possible? Thank you in advance.

here is what i did,see attachment.
15th working day.png

A B

1 START DATE 3/16/2020 formulas used YEAR HOLIDAYS
2 4/1/2020 EOMONTH(B1,0)+1) 2019 1/1/2019
3 15TH WORKDAY 4/22/2020 WORKDAY(B2,15,G2:G21) 1/21/2019
2/18/2019
HOW TO COMBINE THESE TWO FORMULAS IN ONE CELL TO GET THE SAME 5/27/2019
RESULT OF B3? 7/4/2019
9/2/2019
10/14/2019
WHAT I BASICALLY NEED IS THE 15TH WORKING DAY OF THE NEXT 11/11/2019
FOLLOWING MONTH OF A START DATE 11/28/2019
12/25/2019
2020 1/1/2020
1/20/2020
2/17/2020
5/25/2020
7/3/2020
9/7/2020
10/12/2020
11/11/2020
11/26/2020
12/25/2020

[Gregb11]

If I'm understanding correctly, and if your formulas are currently working without issue, then you can just copy the formula you have in B2 in the formula in B3 where you reference B2. Like:
=WORKDAY((EOMONTH(B1,0)+1),15,G2:G21)