Forum Discussion
Solved
The date format is wrong when I concatenate
Hello everyone, I'm quite new to this, sorry if maybe I missed the answer somwhere else. I'm trying to automate the creation of Gcal files for our work planning, which are in that format : ...
MathGILLES You can use the TEXT function for this:
=CONCAT("WorkA";",";TEXT($B31;"mm/dd/yyyy");",";"10:00")
or
="WorkA,"&TEXT($B31;"mm/dd/yyyy")&",10:00"
MathGILLES You can use the TEXT function for this:
=CONCAT("WorkA";",";TEXT($B31;"mm/dd/yyyy");",";"10:00")
or
="WorkA,"&TEXT($B31;"mm/dd/yyyy")&",10:00"
HansVogelaar
It worked perfectly, thanks so much 🙂
