show only date vs date time using Concatenate formula
I am using the formula below to display 2 dates in a single cell but its displaying "date time - date time" vs just "date - date". In the original cells only the date displays (no time). Any suggestions on how to set the formula?
=[Start Date]49 + "-" + [Actual End Date]49
currently shows 10/6/2020 8:00 AM-10/08/2020 4:59 PM
would like it to appear 10/6/2020-10/08/2020
Thanks!
Best Answer
-
Try this:
=LEFT([Start Date]49, FIND(" ", [Start Date]49)) + "-" + LEFT([Actual End Date]49, FIND(" ", [Actual End Date]49))
Hope that helps.
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
Answers
-
Try this:
=LEFT([Start Date]49, FIND(" ", [Start Date]49)) + "-" + LEFT([Actual End Date]49, FIND(" ", [Actual End Date]49))
Hope that helps.
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
-
Worked like a charm! Thanks @Ramzi
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!