Concatenate dates with strikethrough

[9ballpimp]

Hello! I hope someone can help with this. What I am trying to do is concatenate 2 (or more) dates, and apply a strikethrough to the first date (or all but the last date). I can successfully concatenate two dates with a alt-enter by using:

=TEXT(A1,"m/d/yyyy")&CHAR(10)&TEXT(A2,"m/d/yyyy")

Even if I add a strikethrough to the date in A1, it does not carryover into the concatenated cell. Does anyone know how I can do this? Any help would be greatly appreciated!

 

[Norie]

Concatenation doesn't carry over formatting, just values.

The only way to do it would be to use VBA, and that would involve changing the formula to it's value.

 

[PCL]

How is the format of the cell where the formula is, is there a StrikeThrough font?

 

[9ballpimp]

Yes, A1 has a strikethrough, but the formatting does not carryover.

 

[PCL]

How is the format of the cell where is

=TEXT(A1,"m/d/yyyy")&CHAR(10)&TEXT(A2,"m/d/yyyy")

Is there a strikethrough
No as Norie mentioned it:
formatting does not carryover by formula