Adding 3 sequential months in one Cell based on a date

[bearcub]

I have situation where I have new people who are paid monthly draws for the first three months of their employment.

What I would like to do is to have a formula that will populate one cell with EOM dates to remind me when to include them in payroll.

I just missed a couple of draws last month because I thought the rep's first payment was to be in Oct. I realized after the fact it was supposed to start in Sept.

So I thought, if it was possible, is to have a formula that I could use that would populate the first 3 pay dates. The result in the formula cell should be the first EOM date after their hire month.

Is this possible?

I know that I could have these month end dates populates over 3 rows in an array but I would rather have them in one cell if possible.

Example:

Criteria (Cell B3)
State date: 8/20/2020

Result (all dates are one cell):
9/30/2020, 10/31/2020,, 11/30/2020

Thank you in Advance,

Michael

 

[bearcub]

will do

 

[Fluff]

Many thanks

 

[C Moore]

=TEXT(EOMONTH(B3,0),"mm/dd/yy")&", "&TEXT(EOMONTH(B3,1),"mm/dd/yy")&", "&TEXT(EOMONTH(B3,2),"mm/dd/yy")

 

[bearcub]

I've updated my profile as requested