Hello,
I am pulling together a string of data including a date with Concatenate and Index/Match. What is being returned is the serial date. How do I format it to a presentable date? It is the index match highlighted in red.
Thanks
=CONCATENATE("WO ",INDEX(WL[WORK ORDER
'#],MATCH(B2,WL[BE],0),1)," WF BE ",B2," ",INDEX(WL[Building Name],MATCH(B2,WL[BE],0),1)," Scheduled ",INDEX(WL[Start Date],MATCH(B2,WL[BE],0),1))
I am pulling together a string of data including a date with Concatenate and Index/Match. What is being returned is the serial date. How do I format it to a presentable date? It is the index match highlighted in red.
Thanks
=CONCATENATE("WO ",INDEX(WL[WORK ORDER
'#],MATCH(B2,WL[BE],0),1)," WF BE ",B2," ",INDEX(WL[Building Name],MATCH(B2,WL[BE],0),1)," Scheduled ",INDEX(WL[Start Date],MATCH(B2,WL[BE],0),1))