Date in Cell with Text

[Datatellsall2]

Hello -

I'm trying to calculate headers for a workbook, where we have a new header by date. The headers would be named "Key Accomplishments: 11/25/18"... "Key Accomplishments: 12/09/18", etc.

Right now my formula is: =LEFT($O$1,20) &" " & RIGHT(O1,10)+14 which returns: Key Accomplishments: 43444. How do I make the 43444 return as a date value?

Thanks,
M

 

[mikerickson]

Try
=LEFT($O$1,20) &" " & TEXT(RIGHT(O1,10)+14,"m/dd/yy")

 

[jtakw]

Hi,

Your formula (unless it's a typo), will error out for your given sample.

=LEFT($O$1,20) &" " & RIGHT(O1,10)+14

Try this:

Book1
	O	P
1	Key Accomplishments: 11/25/18	Key Accomplishments: 12/09/18
Sheet384

Cell Formulas
Range	Formula
P1	=LEFT($O$1,20)&" "&TEXT(RIGHT(O1,8)+14,"mm/dd/yy")