Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

Cant Change Date Format within formula

Copper Contributor

I am using the CONCAT function to pull the data from the table below to help streamline our scheduling process, but when the function pulls the date from F12 it changes it to the 5 digit format. I tried to format the cell with the formula to show the correct date format, but its not doing anything.

 

 

Capture.PNG

2 Replies
best response confirmed by KyleBaker183 (Copper Contributor)
Solution

@KyleBaker183 Rather than just F12, use TEXT(F12, "dd-mmm-yyyy")

AWESOME!

That worked perfectly. Thank you!
1 best response

Accepted Solutions
best response confirmed by KyleBaker183 (Copper Contributor)
Solution

@KyleBaker183 Rather than just F12, use TEXT(F12, "dd-mmm-yyyy")

View solution in original post