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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!