Generating a column with a series of date excluding months Apr, Aug and Dec

[planiolro]

Dear all

I am supposed to generate a column with the following pattern:

Jan 2016
Feb 2016
Mar 2016

May 2016
Jun 2016
July 2016

Sep 2016
Oct 2016
Nov 2016

Jan 2017
Feb 2017
Mar 2017

May 2017
Jun 2017
July 2017
..................................
until I reach March 2027.

Basically I need to exclude the following months: Apr, Aug and Dec

Is there any way I could do this through a formula so as I do not have to type in manually the info I need?

Thank you in advance.

 

[JimM]

Assuming first date is in A1

then A2
=IF(MOD((MONTH(A1)+1),4)=0,EDATE(A1,2),EDATE(A1,1))

and copy down

 

[Fluff]

If you want to keep the blank rows as shown in your op, try in A2
=IF(MOD(ROW(),4)=0,"",EDATE($A$1,ROW(A1)))

 

[planiolro]

Assuming first date is in A1

then A2
=IF(MOD((MONTH(A1)+1),4)=0,EDATE(A1,2),EDATE(A1,1))

and copy down

Excellent! I worked absolutely fine. What about the following pattern:

56/3
56/3
56/3
56/4
56/4
56/4
56/5
56/5
56/6
....
Where the digits on left hand side before the "/" represent the age and the digit/s after the "/" represent the months and therefore the number after the "/" can't be bigger than 12.

 

[JimM]

How are you calculating the age?
Have you got an example you can give us?