Combining date and time columns

Ideally, we would like to combine a date column and a time column, but displayed in MM/DD/YYYY format. I currently have the date column set to YYYY-MM-DD. I'm not able to figure out a formula that would transpose the dates into a second column. I was thinking some variation of a =MONTH + DAY + YEAR formula would do it, but I can't get it to work all within one cell. We're already in a huge spreadsheet and would prefer not to have to do MON DAY YEAR into three separate columns then combine.

Our desired end result is MM/DD/YYYY HH:MM in military time. I've been able to figure out the time conversion and combining the date/time into second and third columns. It's the date format that is hanging me up.

We'll be using an export of the sheet and if the date and time are in text format, that is perfect.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!