Adding 3 sequential months in one Cell based on a date

bearcub

Well-known Member
Joined
May 18, 2005
Messages
624
Office Version
  1. 365
  2. 2013
  3. 2010
  4. 2007
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,138
Office Version
  1. 365
Platform
  1. Windows
Many thanks (y)
 

C Moore

Well-known Member
Joined
Jan 17, 2014
Messages
540
Office Version
  1. 365
Platform
  1. Windows
=TEXT(EOMONTH(B3,0),"mm/dd/yy")&", "&TEXT(EOMONTH(B3,1),"mm/dd/yy")&", "&TEXT(EOMONTH(B3,2),"mm/dd/yy")
 

bearcub

Well-known Member
Joined
May 18, 2005
Messages
624
Office Version
  1. 365
  2. 2013
  3. 2010
  4. 2007
Platform
  1. Windows
I've updated my profile as requested
 

Watch MrExcel Video

Forum statistics

Threads
1,114,065
Messages
5,545,786
Members
410,706
Latest member
antstt
Top