concatenating dates

[Xtopher]

G'Day All,

I have a date in cell A1 - lets say 26/07/2010.

I have a formula in cell A2 that displays a string of text

="string "

Then references cell A1

& A1

Then adds a hyphen for seperation

& " - "

Then adds 7 to the A1 (for an extra 7 days)

& A1+7

To which this is displayed;

string 40385 - 40392

="string "& A1 & " - " & A1+7

My question is; Can I display the integers as the dates they are, or am I restricted to integers?

[Mordred]

I don't understand. Why not just do this:

=A1+7

[Mordred]

If you want to have a string within the cell and the date you have to do something like this in VBA:

Range("A1").Value = Date
Range("A2").Value = "String" & "-" & Date

[Xtopher]

I solved my own problem!!

="string" & TEXT(A1, "dd/mm/yyyy") & " - " & TEXT(A1+6, "dd/mm/yyyy")

Thanks anyway

[Mordred]

Now I got ya!