software

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 06Cell A1 displays Sun 01 Jan 06 and cell A14 displays Sat 14 Jan 06. Is it
possible to do what I am trying?
You can use the text and concatenation functions to combine and format the
cells as you need. Ex: =text(a1,quot;dd Mmm yyquot;) amp; quot; - quot; amp; text(a14,quot;dd Mmm
yyquot;).
This assumes that you've really got dates (not text strings) in a1 and a14.

quot;Patrick Simondsquot; wrote:

gt; On my worksheet is a date column (formatted DDD DD MMM YY), I have a cell
gt; which I want a formula which would incorporate the date from cell A1 and
gt; A14, the result should like something like this:
gt;
gt; 01 Jan 06 - 14 Jan 06
gt;
gt;
gt; Cell A1 displays Sun 01 Jan 06 and cell A14 displays Sat 14 Jan 06. Is it
gt; possible to do what I am trying?
gt;
gt;
gt;

Try this:

=TEXT(A1,quot;dd mmm yyquot;)amp;quot; - quot;amp;TEXT(A14,quot;dd mmm yyquot;)

--

HTH,

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

quot;Patrick Simondsquot; gt; wrote in message
...
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 06Cell A1 displays Sun 01 Jan 06 and cell A14 displays Sat 14 Jan 06. Is it
possible to do what I am trying?