How to format dates using the google sheets CONCATENATE function

You are reading this tutorial because you are trying to join some fields and strings in google sheets using the CONCATENATE function but when it comes to dates, it's converting them to numbers instead of the dates.

In our bank reconciliation worksheets, we like to generate a link for the PL manager so they can generate a list of invoices at the end of each month.

So in our sheet, we have two fields with  "Start Date" and "End Date".

NOTE: These dates are in EU date format as in dd/mm/yyyy and in our final link we need to convert them to US style dates: yyyy-mm-dd



As you can see the Link is a combination of a URL and the two dates and for this, we are using a mixture of CONCATENATE and TEXT to get the desired result of the dates.

=CONCATENATE("https://www.yourlink.com?start=", TEXT(C4,"YYYY-MM-DD"), "&end=",TEXT(C5,"YYYY-MM-DD"))


You can experiment with the dates too, for example, dropping in the following code would output Saturday in front of the date.

TEXT(C4,"DDDD, YYYY-MM-DD")



  • google sheets, concat
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Photo snag list format

You are reading this because we have asked you to send us references to stock photos.Its not...

What is a snag list?

You are reading this article because you would like to know what a snag list is in relation to...

How to refresh your browser

You are reading this page because you are looking at a web page which has been changed but its...

Activating 2FA on Your Wordpress sites using Wordfence Log in Security Plugin

This tutorial will show you how to enable two-factor authentication for your user profile on...

How to clean up spam entries in gravity forms

Gravity forms is a fantastic forms plugin, however if you have a popular web site it can become a...