Text and date in Same cell

[davids4500]

I want to add the text in B9, "Last Years Sales" and in the same cell give the date in cell B4 which is Sept 2024 so that is shows as Sept 2023

 

[JoeMo]

Assuming you mean add the text in B9 to the date in cell B4 which is Sept 2024 so that is shows as Sept 2024:

SpeedTest.xlsm
	B	C	D
4	Sep 2024		Last Years Sales Sep 2024
5
6
7
8
9	Last Years Sales
Sheet2

Cell Formulas
Range	Formula
B4	B4	=DATE(2024,9,1)
D4	D4	=B9&" "&TEXT(B4,"mmm yyyy")

 

[davids4500]

Assuming you mean add the text in B9 to the date in cell B4 which is Sept 2024 so that is shows as Sept 2024:

I want to add the text in B9, "Last Years Sales" and in the same cell give the date in cell B4 which is Sept 2024 so that is shows as Sept 2023

Let me write this again...I want to add to the text in B9, which is "Last Years Sales" and in the same cell insert the date that is in cell B4 (which is Sept 2024) so that is shows as Last Years Sales Sept 2023... (Note the date of the previous year)

 

[Phuoc]

Try change to:

=B9&" "&TEXT(EDATE(B4,-12),"mmm yyyy")

 

[davids4500]

=B9&" "&TEXT(EDATE(B4,-12),"mmm yyyy")

thank you Phuoc. Much appreciated