Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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

2 Answers 2

up vote 4 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")

Source

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! –  Barry Aug 23 '12 at 7:19

Your Answer

 
discard

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.