How to Copy a Formatted Date in its Formatted Form

I am trying to use CALC to create a LaTeX template, with sequential dates.

On a given row I have the following cells, represented here by vertical bars:

| \datehead{ | Wednesday, May 1, 2024 | }~—~ | =CONCAT(A7,B7,C7)

The second column was entered as 2024-05-01, then formatted to text

The CONCAT function resolves to \datehead{45413 }~—~

What I am looking for, however, is \datehead{Wednesday, May 1, 2024}~—~**

This should be easy, but I am feeling real stupid at the moment.**

I thought I had in the past been able to copy the formatted date into another cell using a paste-special option, but I can’t get it to work.

Thanks for any suggestions/help.

How about

1 Like

Thanks, EarnestAl. That did it.