Date with TEXT add one month with TEXT

[ozbeachbum]

I have the following formula;
=TEXT(Jul!D44,"Mmm")&":"
and would like to increase by one month including the TEXT.
I have tried a number of TEXT with DATE Functions without success.
Any help appreciated.

 

[Fluff]

How about

=TEXT(edate(Jul!D44,1),"Mmm")&":"

 

[Phuoc]

Try this

=TEXT(Jul!D44,"Mmm")&":"&TEXT(EDATE(Jul!D44,1),"Mmm")

 

[ozbeachbum]

Hi Fluff,

=TEXT(edate(Jul!D44,1),"Mmm")&":" Does bring through Aug based on Jul!D44.

I should have been clearer on my first post.
=TEXT(edate(Jul!D44,1),"Mmm")&":" is in EY86 and what I was looking for was a formula which I could enter in EY87 and drag down to get each of the following months + text.

I tried adjusting your formula to =TEXT(edate(EY86,1),"Mmm")&":" but I get Error in Value.

Trust this makes my request clearer.

 

[ozbeachbum]

Try this

=TEXT(Jul!D44,"Mmm")&":"&TEXT(EDATE(Jul!D44,1),"Mmm")

Thanks Phuoc,
Unfortunately did not work, returned "HOW"

 

[Fluff]

How about, in ey86

=TEXT(edate(Jul!D$44,rows(ey$86:ey8)6),"Mmm")&":"

 

[bebo021999]

In EY86:

=TEXT(edate(Jul!$D$44,rows($1:1)),"Mmm")&":"

drag down

 

[ozbeachbum]

How about, in ey86

=TEXT(edate(Jul!D$44,rows(ey$86:ey8)6),"Mmm")&":"

This might be of more helpful.

240916 date + text.xlsx
	EX	EY	EZ	FA
85
86		Jul:
87	Based on EY86	Aug:	Jan:	<-- It won't accept your formula TEXT(edate(Jul!D$44,rows(ey$86:ey8)6),"Mmm")&":" and changes it as shown.
88	Based on EY87	Sep:
89		and so on.
90
Blank

Cell Formulas
Range	Formula
EY86	EY86	=TEXT(Jul!D44,"Mmm")&":"
EZ87	EZ87	=TEXT(EDATE(Jul!D$44,ROWS(EY8:EY$86)*6),"Mmm")&":"

 

[Fluff]

Oops, slight typo, it should be

=TEXT(edate(Jul!D$44,rows(ey$86:ey86)),"Mmm")&":"

 

[ozbeachbum]

Oops, slight typo, it should be

=TEXT(edate(Jul!D$44,rows(ey$86:ey86)),"Mmm")&":"

Thought it might have been.
This one works perfectly.
Thanks once again.
Cheers,
Dave.