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.