Start Date with Target Days to Future Month

[MPG Radio]

Hello all, not sure how to word this, if I have an Excel start date in one cell and in another cell a number, what future month in the year would this be.

Thank you hope you can help.

 

[etaf]

you could use
=TEXT(A1+B1,"MMMM")

Book4
	A	B
1	date	days to target
2	4/12/24	63
3
4		future month
5		June
Sheet1

Cell Formulas
Range	Formula
B5	B5	=TEXT(A2+B2,"MMMm")

Book4
	A	B
1	4/12/24	63
2
3		June
4
5
6
7		6/14/24
Sheet1

Cell Formulas
Range	Formula
B3	B3	=TEXT(A1+B1,"MMMm")
B7	B7	=A1+B1

 

[MPG Radio]

Thank you so much etaf, this works very well indeed.

 

[etaf]

you are welcome