Search code examples
dategoogle-sheetsmergeformattingformula

Google Sheets: Combining Dates From Two Different Columns into Third Column W/Proper Date Formatting

I have two columns. One contains start date and the other contains end date in the following format: YYYY-MM-DD

I'm trying to create a third column that combines the two dates to produce: "YYYY-MM-DD to YYYY-MM-DD"

I tried the following formula: =M2&" to "&N2

  • M2 and N2 are the start and end dates respectively

But it gives me back the dates in numbers like so (but I want the dates): 45047 to 45074

Any suggestions on how to fix my issue?

Solution

  • You may try:

    =to_text(M2)&" to "&to_text(N2)