Using cell contents within a formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Patrick Simonds - 17 Dec 2005 21:31 GMT

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?

Reply to this Message

bpeltzer - 17 Dec 2005 21:45 GMT

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.

> 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
[quoted text clipped - 4 lines]
> Cell A1 displays Sun 01 Jan 06 and cell A14 displays Sat 14 Jan 06. Is it
> possible to do what I am trying?

Reply to this Message

RagDyeR - 17 Dec 2005 21:52 GMT

Try this:

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

Signature

HTH,

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

Reply to this Message