Could you help me adjust formula?

[Sean15]

Hi:

Could you help me adjust formula in D8?

BUDGET 2024.xlsx
	C	D	E
2			12/1/2024
3
4
5
6
7
8		#VALUE!
9
10	D8 should be	Bank bal at 12/31/24
Sheet2

Cell Formulas
Range	Formula
D8	D8	="Bank bal at " &EOMONTH(TEXT(E2,0),"mm/dd/yy")

 

[hagia_sofia]

Hello, try:

="Bank bal at "&TEXT(EOMONTH(E2,0),"mm/dd/yy")

 

[etaf]

if its a real date in E2
then
="Bank bal at " &TEXT(EOMONTH(E2,0),"mm/dd/yy")

 

[Sean15]

Thank you very much.

 

[etaf]

you are welcome