Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Given say 2 different dates in A1 and B1, what I want to do is just show the range of dates as a label in A2 by using =concatenate(A1, " - ", A2)

However, A1 is in the default format (MM/DD/YYYY) and I want the label to have dates in the format DD MON, YYYY (as in 12/21/2012 -> 21st Dec, 2012).

Seems like this shouldn't be too complicated, but I couldn't find any way to do so by searching so far. I guess I could copy the same date into a different hidden cell with the appropriate format, and reference that for the concatenate function call - but I'd rather do so directly if possible.

So what I'm looking for is something like =concatenate(FORMAT(A1, 'DD MON YYYY'), " - ", FORMAT(A1, 'DD MON YYYY')) except I can't find a suitable function.

share|improve this question
up vote 8 down vote accepted

There isn't a format function in Google spreadsheets. You have to use the TEXT(number, format) function.

I have to admit I always assume it will be format, but Excel uses Text so Google has to use it also.

share|improve this answer

This worked great for me:

=A1&TEXT(A2," mmmm d, yyyy")


share|improve this answer
Welcome to Web Applications! Please don't post answers with just links. If the links becomes dead your answer is useless. Provide the actual answer in your post and if need be, link to the source. I suggest that you take some time to read the FAQ. Thanks! – codingbadger Aug 23 '12 at 7:19
Is there a list of mm dd yy type of formats Google Sheets supports? – Zlatty Apr 6 at 15:45

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.