How to extract the date of a cell stored as "dd/mm/yyyy hh:mm" format

Question

I have a cell that holds a date/time value in the following format: dd/mm/yyyy hh:mm.

Now I need to extract the date from it as a string and append a different time to it. And I need the final result as a string. What's the best way to do this?

Answer 1

If stored as a Date then you can use int() to remove the time part of the date value and then add another time part. If stored as text then use left(cell, 10) to obtain just the dd/mm/yyyy part. You can convert dates to strings using text(cell, "dd/mm/yyyy") etc, and you can convert strings to dates using datevalue ("dd/mm/yyyy").