Using cell contents within a formula

[Patrick Simonds]

On my worksheet is a date column (formatted DDD DD MMM YY), I have a cell
which I want a formula which would incorporate the date from cell A1 and
A14, the result should like something like this:

01 Jan 06 - 14 Jan 06


Cell A1 displays Sun 01 Jan 06 and cell A14 displays Sat 14 Jan 06. Is it
possible to do what I am trying?

 

[Guest]

You can use the text and concatenation functions to combine and format the
cells as you need. Ex: =text(a1,"dd Mmm yy") & " - " & text(a14,"dd Mmm
yy").
This assumes that you've really got dates (not text strings) in a1 and a14.

 

[RagDyeR]

Try this:

=TEXT(A1,"dd mmm yy")&" - "&TEXT(A14,"dd mmm yy")

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

On my worksheet is a date column (formatted DDD DD MMM YY), I have a cell
which I want a formula which would incorporate the date from cell A1 and
A14, the result should like something like this:

01 Jan 06 - 14 Jan 06


Cell A1 displays Sun 01 Jan 06 and cell A14 displays Sat 14 Jan 06. Is it
possible to do what I am trying?