Just saying that the equations "dont work" is not a very helpful description
if you want help in solving your problems.
If you tell us what formula you used, what values were in the cells leading
into the formula, what result you got, and what result you expected, that
would be a good start.
One likely problem area if you are playing with dates is the question as to
whether the cells contain numbers formatted as dates or whether they contain
text. You can check this in a number of ways. One option is to use
=ISTEXT(D4) and =ISNUMBER(D4). Another option is to try Format/ Cells/
Number/ Date to see whether the cell can be changed from 26-Apr to display
temporarily in a different format such as 26/4/08 or 26 April 2008; if it
doesn't change, you're starting with text, but if it does change it is a
number formatted as text.
Having resolved the question above, if you have a number formatted as text
and you want to use it in a concatenation formula, you'll presumably want to
use the TEXT function to format it the way you want it.
So =CONCATENATE(D4,", ",E4) might become =CONCATENATE(TEXT(D4,"dd-mmm"),",
",E4)
or =D9&", "&E9 might become =TEXT(D9,"dd-mmm")&", "&E9
Change the formatting string "dd-mmm" to suit how you want the number
presented.
