Display first instance of month

[Finalfight40]

Hi All

I have a dates similar to below:

[TABLE="width: 500"]
<tbody>[TR]
[TD]July[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]August[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]02/07/2018[/TD]
[TD]09/07/2018[/TD]
[TD]16/07/2018[/TD]
[TD]23/07/2018[/TD]
[TD]30/07/2018[/TD]
[TD]06/08/2018[/TD]
[TD]13/08/2018[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I would like to know if there is a formula to display the month names above the first instance of that month occurring. Also the following year, the month would would need to appear again (for example July next year would need July above the first instance).

Also my data starts in B13

 

[Chameleon64]

I've assumed the dates start in B13:

=IF(OR(A13="",(MONTH(B13)-MONTH(A13))=1,(MONTH(B13)-MONTH(A13))=-11),CHOOSE(MONTH(B13),"January","February","March","April","May","June","July","August","September","October","November","December"),"")

The OR statement checks if there's a difference in months between the date in the same column as the formula and the date in the previous column. If the difference is 1 or -11 (for January) then it displays the month in text from the CHOOSE list. The A13=0 in the OR function is there to cater for the first date only.

 

[Finalfight40]

Hi Chameleon

I got a value error with your formula, however your use of Choose and explanation gave me a great idea to solve it.

Thank you!

 

[Peter_SSs]

What about this, copied across?

Excel Workbook
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
12	July					August				September				October
13	2/07/2018	9/07/2018	16/07/2018	23/07/2018	30/07/2018	6/08/2018	13/08/2018	20/08/2018	27/08/2018	3/09/2018	10/09/2018	17/09/2018	24/09/2018	1/10/2018	8/10/2018
Start of Month

 

[Finalfight40]

Hi Peter

That explains why when i tried this method i couldn't get the right answer!

When i tried, i used:

[COLOR=#000000][FONT=Arial]=IF(MONTH[/FONT][/COLOR][COLOR=#000000][FONT=Arial](B13)[/FONT][/COLOR][COLOR=#000000][FONT=Arial]=MONTH[/FONT][/COLOR][COLOR=#000000][FONT=Arial](A13)[/FONT][/COLOR][COLOR=#000000][FONT=Arial],"",TEXT[/FONT][/COLOR][COLOR=#000000][FONT=Arial](MONTH(B13),"mmmm")[/FONT][/COLOR][COLOR=#000000][FONT=Arial])

Which of course always returned January...

Silly mistake.[/FONT][/COLOR]

 

[Peter_SSs]

Which of course always returned January...

Yes, it certainly would.